Unable to recreate / drop an already deleted schema with same name
STEPS TO REPRODUCE:
1. Create a Phoenix connection
2. CREATE SCHEMA test
3. DROP SCHEMA test
4. Now create the test schema again. This will throw below exceptions :
0: jdbc:phoenix:> create schema "test";
Error: ERROR 721 (42M04): Schema with given name already exists schemaName=test (state=42M04,code=721) org.apache.phoenix.schema.SchemaAlreadyExistsException: ERROR 721 (42M04): Schema with given name already exists schemaName=test
5. Now attempt to drop the test schema again:
0: jdbc:phoenix:> drop schema "test";Error: ERROR 722(43M05):Schema does not exists schemaName=test (state=43M05,code=722) org.apache.phoenix.schema.SchemaNotFoundException: ERROR 722(43M05):Schema does not exists schemaName=test
If you look in Hbase and list_namespace, you will see the test schema still exists.
ROOT CAUSE : This is a known issue discussed in Apache JIRA PHOENIX-3694
SOLUTION : Issue is fixed in Phoenix 4.10. For a backport hotfix , please log a case with HWX.
