Support Questions
Find answers, ask questions, and share your expertise

Droping Hive tables Crashed Hive Server, Cant drop hive table

Contributor

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.

https://community.hortonworks.com/questions/23690/dropping-hive-table-crashes-hiveserver2.html

kindly guide

3 REPLIES 3

Re: Droping Hive tables Crashed Hive Server, Cant drop hive table

@Mathi Murugan

Try setting hive.metastore.try.direct.sql=false and hive.metastore.try.direct.sql.ddl=false, then execute the drop query.

Re: Droping Hive tables Crashed Hive Server, Cant drop hive table

Contributor

Hi Sindhu,

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 1.2.1.2.4

hive-error.txt

Re: Droping Hive tables Crashed Hive Server, Cant drop hive table

@Mathi Murugan

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

Follow this KB Article for this step.

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