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 are the different components of a Hive query processor?
Can we change the data type of a column in a hive table?
How do you specify the table creator name when creating a table in hive?
Hive new version supported Hadoop Versions ?
List the various options available with the Hive command?
TRIM function in Hive with example?
What happened after creating a table in hive ?
In case of embedded Hive, can the same metastore be used by multiple users?
Explain ALTER Table statement in Hive?
Explain Data Type Conversion in Hive?
How to change the column data type in hive? Explain rlike in hive.
What is the current version of Hive?
What is the maximum size of string data type supported by Hive?
What is Hive Data Definition language?
What will happen in case you have not issued the command?