Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

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?


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.

Super Collaborator


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

Is this another missing jar?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.