Top "External-tables" questions

To be used for External tables.

Does DROP PARTITION delete data from external table in HIVE?

An external table in HIVE is partitioned on year, month and day. So does the following query delete data from …

hive external-tables hive-partitions hiveddl
Change external table BADFILE, LOGFILE and DISCARDFILE parameters only

I have several external tables used to read file data into the DB each one for a particular file specification. …

oracle oracle10g external-tables
HIVE External Table - Set Empty Strings to NULL

Currently I have a HIVE 0.7 instance on Amazon EMR. I am trying to create a duplicate of this instance on …

hadoop hive hdfs amazon-emr external-tables
External Tables vs SQLLoader

So, I often have to load data into holding tables to run some data validation checks and then return the …

oracle sql-loader external-tables
Specified partition columns do not match the partition columns of the table.Please use () as the partition columns

here i'm trying to persist the data frame in to a partitioned hive table and getting this silly exception. I …

scala hadoop hive external-tables partition-by
How do "Fixed-length records" and "Fixed-length fields" increases database performance?

Could anyone please explain the below two statements w.r.t the Oracle external table performance improvement with the ORACLE_…

oracle oracle11g external-tables
How to truncate a partitioned external table in hive?

I'm planning to truncate the hive external table which has one partition. So, I have used the following command to …

hive external-tables hive-partitions hiveddl