Can not drop the Hive tables, if i try it results in Hive server down, then after i restarting the Hive server i can able to access the hive shell. The same issue is posted in below link but no suggestion is given.
By setting this property hive.metastore.try.direct.sql=false and hive.metastore.try.direct.sql.ddl=false, does not work.It listed with error which i had attached below, Then i Rolled back those config.Is there any other suggestion to drop hive tables.
I'm using MYSQL -5.6.33 and Hive 188.8.131.52.4
Here is what you need to do in order to resolve your issue:
1. Upgrade mysql-java-connector on - Ambari Server, Hive Metastore and HiveServer.
Restart Hive Metastore and HiveServer from Ambari
2. Follow the steps provided by Sindhu in previous answer:
Set hive.metastore.try.direct.sql=false Set hive.metastore.try.direct.sql.ddl=false
3. Execute drop query