What does the overwrite keyword denote in Hive load statement?
Answer Posted / 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 |
Post New Answer View All Answers
What is dynamic partitioning and when is it used?
What are the components of Hive architecture?
Why is Hive not suitable for OLTP systems?
Mention what is the difference between Hbase and Hive?
What are the advantages and Disadvantages in archieving partition in Hive?
How to managed create a table in hive ?
What is hive metastore?
Mention what is HiveServer2 (HS2)?
What are the file formats that Hive supports and can use be used for storage?
How do you specify the table creator name when creating a table in hive?
What is metastore?
Is hive suitable to be used for oltp systems? Why?
Explain Data Type Conversion in Hive?
What are the types of tables in Hive?
What is the difference between Hiveserver1 and Hiveserver2?