Francis Chuang created PHOENIX-3349:
---------------------------------------
Summary: DROP TABLE not working with schemas
Key: PHOENIX-3349
URL: https://issues.apache.org/jira/browse/PHOENIX-3349
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.8.1
Reporter: Francis Chuang
I am using 4.8.1 with HBase 1.2.3. I am talking to Phoenix using the Phoenix
Query Server (Avatica)
phoenix.schema.isNamespaceMappingEnabled is set to true in my configuration.
To reproduce the problem:
1. Execute CREATE SCHEMA IF NOT EXISTS myschema
2. Open a connection to the query server and set the schema to myschema by
setting the info map to {"schema": "myschema"} in the OpenConnectionRequest:
https://calcite.apache.org/docs/avatica_protobuf_reference.html#openconnectionrequest
2. Execute CREATE TABLE test_table1 (id integer not null primary key)
3. ExecuteUPSERT INTO test_table1 (id) VALUES(1)
Until this point, the schema and table were all created correctly. Upserting
also works. If we check system.catalog, we can confirm that the table was
created as myschema.test_table1.
4. If we attempt to drop the table using the same connection, it neglects to
include the schema, so it fails: DROP TABLE test_table1
{code}
RuntimeException: org.apache.phoenix.schema.TableNotFoundException: ERROR 1012
(42M03): Table undefined. tableName=TEST_TABLE1 -> TableNotFoundException:
ERROR 1012 (42M03): Table undefined. tableName=TEST_TABLE1
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
