Interested to Buy Any Domain ? << Click Here >> for more details...
What does the overwrite keyword denote in Hive load statement?
- 1 Answers
- 2428 Views
- I also Faced
- E-Mail Answers
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 are the different collection type in Hive?
What is Internal and External table in Hive?
How many types of Tables in Hive?
How will you consume CSV file into the Hive warehouse using built SerDe?
Explain ALTER Table statement in Hive?
Can you define serde in hive?
What are hive operators and its types?
What are the file formats that Hive supports and can use be used for storage?
Whenever we run hive query, new metastore_db is created. Why?
Why do we need hive?
While loading data into a hive table using the load data clause, how do you specify it is a hdfs file and not a local file ?
Describe REVERSE function in Hive with example?
-
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)
