What Is The Significance Of ‘if Exists” Clause While Dropping A T

1.	What Is The Significance Of ‘if Exists” Clause While Dropping A Table?
Answer» When we ISSUE the command DROP TABLE IF EXISTS table_name Hive THROWS an ERROR if the table being dropped does not exist in the FIRST place. When we issue the command DROP TABLE IF EXISTS table_name Hive throws an error if the table being dropped does not exist in the first place.

What Is The Significance Of ‘if Exists” Clause While Dropping A Table?

Answer»

When we ISSUE the command DROP TABLE IF EXISTS table_name

Hive THROWS an ERROR if the table being dropped does not exist in the FIRST place.

When we issue the command DROP TABLE IF EXISTS table_name

Hive throws an error if the table being dropped does not exist in the first place.