Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to drop table/db after an update makes it inaccessible?

How to drop table/db after an update makes it inaccessible?

Super Collaborator

Long ago, in a dev environment far away...

I experimentally made a Hive table backed by Phoenix.

Now, after several updates of HDP, I want to drop the table and the database, but am unable to.

When I try to drop the table, I get this error:

Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message: Failed to load storage handler: Error in loading storage handler.org.apache.phoenix.hive.PhoenixStorageHandler).

I'm sure this is because this table was created with a much older version of Phoenix than the one we currently have on our cluster.

But is there a way to clean this up without painfully getting the table working?

Can I manually remove the DB from the Hive metastore?

What are my options?

2 REPLIES 2

Re: How to drop table/db after an update makes it inaccessible?

Super Collaborator

First of all, make sure that you have phoenix-hive.jar in AUX class path. Or you may add it manually in hive shell by add jar command. Also, you may try to turn DEBUG log level and see the full stack trace of the exception to figure out whether the jar is missing or there is some incompatibility in methods (doubt that). You may try to manually drop this table using mssql, but I would not recommend that.

Re: How to drop table/db after an update makes it inaccessible?

Super Collaborator

Thanks.

I added phoenix-hive.jar using "add jar ..." and now the error references org/apache/hadoop/hbase/HBaseConfiguration

Is this another missing jar?

Don't have an account?
Coming from Hortonworks? Activate your account here