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 |
What is bucketing in Hive?
What is Hive query processor?
What is hive installation path?
What does the “USE” command in the hive do?
What are the default read and write classes in Hive?
what Hive query processor does?
Explain REVERSE function in Hive with example?
What are the views in Hive?
Why do we perform partitioning in Hive?
Is it possible to change the default location of Managed Tables in Hive, if so how?
What is indexing and why do we need it?
What is the difference between external table and managed table?
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)