question Re: Drop table is not working in hive. in Support Questions

Drop table is not working in hive.

rodrigo_gallacc — Tue, 23 Jul 2019 03:11:12 GMT

Hello all, I'm a little new in Haddop world, so, please forgive me any kind of questions that I'm doing.

In first place, I installed a 7 node cluster in my environment, all of them has DataNode (I know now that's the worst scenario, but, it's already installed and no time to fix it).

In this morning, a simple process that need to drop a partitioned table in Hive isn't working anymore, there was no modification on cluster.

The simple command is "drop table ods.tims_declaracao;".

Well, I think that I got the problem worse, I removed the directory "/apps/hive/warehouse/ods.db/tims_declaracao". I thought that I would drop the table, well, I realize that it was not.

The table still hanging in drop the metadata. Can some good soul help me to find out what's the problem?

Regards.

Re: Drop table is not working in hive.

edu_vikassri — Wed, 24 Jul 2019 12:59:15 GMT

@Rodrigo Gallacci

Can you please provide information regarding which HDP and hive version you are using?

Its seems like a managed table, are you getting any error logs?

if its hdp3.1 can you usine beeline in debug more like below

beeline --verbose=true

and post the logs ?

Re: Drop table is not working in hive.

rodrigo_gallacc — Wed, 24 Jul 2019 13:32:09 GMT

Thank you for the answer, I found how to fix the problem, I cannot drop the table because there are a table in MySQL that defines what's locked or not.

The table is "HIVE_LOCKS", from hive database, I just deleted the data correlated to my table and I was able to drop it.

Thanks