[ 
https://issues.apache.org/jira/browse/PHOENIX-3349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Francis Chuang updated PHOENIX-3349:
------------------------------------
    Description: 
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}

The same problem can be reproduced with DROP SEQUENCE.

  was:
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}


        Summary: DROP TABLE and DROP SEQUENCE not working with schemas  (was: 
DROP TABLE not working with schemas)

> DROP TABLE and DROP SEQUENCE 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}
> The same problem can be reproduced with DROP SEQUENCE.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to