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 |
I want to see the present working directory in UNIX from hive. Is it possible to run this command from hive?
When to use Hive?
What are the limitations of Hive?
How to create table in hive for a json input file?
Explain about the different types of join in Hive?
Does Hive support record level Insert, delete or update?
if you run Hive as a server?
What are the types of tables in Hive?
Mention what is the difference between Hbase and Hive?
How can you connect an application, if you run hive as a server?
What is CONCATENATE command in Hive?
Difference between SQL and HiveQL ?
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)