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
Is there a date data type in Hive?
What do you mean by schema on reading?
What is the significance of ‘IF EXISTS” clause while dropping a table?
Why do we need hive?
How is HCatalog different from Hive?
What is the default maximum dynamic partition that can be created by a mapper reducer? How can you change it?
If you run hive as a server, what are the available mechanism for connecting it from application?
How to change the column data type in hive? Explain rlike in hive.
How do you write your own SerDe?
Can you define serde in hive?
What is the man difference between hbase and hive?
How can I delete the above index named index_bonuspay?
How can client interact with Hive?
What is bag?
Difference between external table and internal table in HIVE ?