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 |
Can you give us some examples, how Hadoop is used in real time environment?
Can you explain smb join in hive?
Can we say cogroup is a group of more than 1 data set?
Where is table data stored in Apache Hive by default?
Does Pig give any warning when there is a type mismatch or missing field?
What is the difference between like and rlike operators in hive?
What is Clustring in Hive?
What is Hive ?
What is the major difference between local and remote meta-store?
What is CTAS Table in Hive?
Explain Hive Thrift server?
How data transfer happens from HDFS to 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)