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?