adspace


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


Please Help Members By Posting Answers For Below Questions

How can I delete the above index named index_bonuspay?

807


What are the different types of tables available in Hive?

767


Can We Change settings within Hive Session? If Yes, How?

859


When to choose "External Table" in Hive?

867


What is a Hive variable? What for we use it?

880


When to use explode in Hive?

832


Where does the data of a Hive table gets stored?

750


When we are using queries instead of scripting?

801


How to skip header rows from a table in Hive?

907


What is the stable version of Hive ?

2695