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?
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.
I added phoenix-hive.jar using "add jar ..." and now the error references org/apache/hadoop/hbase/HBaseConfiguration
Is this another missing jar?