If you omit the OVERWRITE clause while creating a hive table,what happ

1.	If you omit the OVERWRITE clause while creating a hive table,what happens to file which are new and files which already exist?
Answer» The new incoming files are just added to the target directory and the existing files are simply overwritten. Other files whose name does not match any of the incoming files will continue to exist. If you add the OVERWRITE clause then all the existing data in the directory will be deleted before new data is written.

If you omit the OVERWRITE clause while creating a hive table,what happens to file which are new and files which already exist?

Answer»

The new incoming files are just added to the target directory and the existing files are simply overwritten. Other files whose name does not match any of the incoming files will continue to exist.

If you add the OVERWRITE clause then all the existing data in the directory will be deleted before new data is written.

Discussion

No Comment Found

Related InterviewSolutions

How do you specify the table creator name when creating a table in Hive?
The following statement failed to execute. What can be the cause?LOAD DATA LOCAL INPATH ‘${env:HOME}/country/state/’OVERWRITE INTO TABLE address;
What is a generic UDF in hive?
Can a partition be archived? What are the advantages and Disadvantages?
What does /*streamtable(table_name)*/ do?
What is bucketing ?
Give the command to see the indexes on a table.
What types of costs are associated in creating index on hive tables?
Can we LOAD data into a view?
Can the name of a view be same as the name of a hive table?

If you omit the OVERWRITE clause while creating a hive table,what happens to file which are new and files which already exist?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment