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 SHOW and DESCRIBE Commands in Hive?
How can client interact with Hive?
What is Hive query processor?
What is the prerequisite for Apache Hive installation?
What is metastore?
What are the different components of a Hive architecture?
What kind of applications is supported by Apache Hive?
What is the functionality of Query Processor in Apache Hive?
What are the different components of a Hive query processor?
Can a table be renamed in Hive?
What types of costs are associated in creating index on hive tables?
What is sample Query in Hive?
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)