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 |
Explain REPEAT function in Hive with example?
What is the default maximum dynamic partition that can be created by a mapper reducer? How can you change it?
How to load data into table created in hive ?
what does /*streamtable(table_name)*/ do?
Explain the Use of Hive?
When a large data set is maintained?
How can you configure remote metastore mode in Hive?
Mention if we can name view same as the name of a Hive table?
Is it possible to use the same metastore by multiple users, in case of the embedded hive?
What are the different parts of Hive ?
When should we use SORT BY instead of ORDER BY?
Differentiate between describe and describe extended?
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)