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 the precedence order of hive configuration?
What are the differences between Hive and RDBMS?
What are the file formats that Hive supports and can use be used for storage?
Give examples of the SerDe classes whihc hive uses to Serializa and Deserilize data?
Can the name of a view be same as the name of a hive table?
What will be the output of cast ('XYZ' as INT)?
what is Metastore in Hive?
What are the different Primitive Data Types available in Hive?
LOWER or LCASE function in Hive with example?
What kind of datawarehouse application is suitable for Hive?
Why Hive is not suitable for OLTP systems?
What is the stable version of 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)