create external table demotable( column1 string, column2 string, column3 string) row format delimited fields terminated by '|' location '/data/demotable'; I create external table 'demotable' and...

I'm planning to truncate the hive external table which has one partition. So, I have used the following command to truncate the table : hive> truncate table abc; But, it is throwing me an e...

I am trying to use the bigquery export functionality to push data out to GCS in json format. At the end of the process inorder to validate the count of exported records in the GCS file, I am creati...

I have a Spark application that writes output files in Avro format. Now I would like that data to be available in Hive, because an application which would utilise that data can only do so through a...

I am new to azure databricks and trying to create an external table, pointing to Azure Data Lake Storage (ADLS) Gen-2 location. From databricks notebook i have tried to set the spark configuration...

I have created the hive external table using below command: use hive2; create external table depTable (depId int comment 'This is the unique id for each dep', depName string,location string) com...

Is it possible to create n number of external tables are pointing to a single hdfs path using Hive. If yes what are the advantages and its limitations.

So, I often have to load data into holding tables to run some data validation checks and then return the results. Normally, I create the holding table, then a sqlldr control file and load the data ...

An external table in HIVE is partitioned on year, month and day. So does the following query delete data from external table for the specific partitioned referenced in this query?:- ALTER TABLE M...

I am new to Hadoop and learning Hive. In Hadoop definative guide 3rd edition page no. 428 last paragraph I don't understand below paragraph regarding external table in HIVE. "A common pattern is...