What does the overwrite keyword denote in Hive load statement?
Answer / rajasekhar
suppose in the current table in hive we are having 3 columns and data is there. If we r adding
one more column then data will be show as null for the new column to overcome this we are using overwrite keyword.
using overwrite keyword data will be loaded with the new table schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
When you point a partition of a hive table to a new directory, what happens to the data?
When we are using queries instead of scripting?
How can client interact with Hive?
what is (HS2) HiveServer2?
How do you check if a particular partition exists?
How can you delete the DBPROPERTY in Hive?
Can a partition be archived? What are the advantages and Disadvantages?
How can you configure remote metastore mode in Hive?
What is the man difference between hbase and hive?
I want to see the present working directory in UNIX from hive. Is it possible to run this command from hive?
How do you write your own SerDe?
What is the purpose of Hive Driver?
Apache Hadoop (394)
MapReduce (354)
Apache Hive (345)
Apache Pig (225)
Apache Spark (991)
Apache HBase (164)
Apache Flume (95)
Apache Impala (72)
Apache Cassandra (392)
Apache Mahout (35)
Apache Sqoop (82)
Apache ZooKeeper (65)
Apache Ambari (93)
Apache HCatalog (34)
Apache HDFS Hadoop Distributed File System (214)
Apache Kafka (189)
Apache Avro (26)
Apache Presto (15)
Apache Tajo (26)
Hadoop General (407)