in Big Data | Hadoop by
Q:
EXIST in Drop Table hive

1 Answer

0 votes
by

We use IF EXISTS clause in DROP TABLE statement. When we drop a table, there can be a case that table does not exist. In such a case DROP statement will give error.

In case we are not sure if the table exists or not in Hive, we use DROP TABLE IF EXISTS

 

tableName statement to drop a table. This statement will not give error in case table does not exist.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
0 votes
asked Sep 7, 2019 in Big Data | Hadoop by john ganales
0 votes
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
...