Why we need to use IF NOT EXIST command during Hive Table creation?

Duringhive Hive Table or Database creation we are usually using “if not exist” command. Hive is not allowing to create the same table name and it throws the error.

In real time we are using more number of tables and in “Data lake” concepts these hive tables are belongs to injection layer, staging layer and production or final layer like these concepts.

So, Hive tables are created by using “If not exist” command so that if the table is already there, this command will recreate the table without any error throwing.
if-not-exists-command-in-hive

 

 

Leave a Reply