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 difference between Cassandra, Pig and Hive?
When to use Hive?
CONCAT function in Hive with Example?
If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?
Explain about Hive Buckets with Example ?
I want to see the present working directory in UNIX from hive. Is it possible to run this command from hive?
What is the current version of Hive?
What are the views in Hive?
What does the "USE" command in hive do?
What is Hive Data Definition language?
What is the need for custom serde?
Explain what is a Hive variable. What do we use it for?
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)