Amanchi Venkata Subbarayudu created PHOENIX-3750:
----------------------------------------------------
Summary: Phoenix Namespace : DDL statements support
Key: PHOENIX-3750
URL: https://issues.apache.org/jira/browse/PHOENIX-3750
Project: Phoenix
Issue Type: Test
Affects Versions: 4.8.0, 4.8.1
Reporter: Amanchi Venkata Subbarayudu
Starting from v4.8.0, phoenix enables to specify a schema to connect to, and
all the DML operations performed are executed with respective schema tables.
As of now, it seems that only supported DDL command is CREATE operation with
schema support, i.e.
Assuming schema is set using one of the below
a. JDBC URL = localhost;schema=TSCHEMA
b. HBASE-CONFIG: with property phoenix.connection.schema=TSCHEMA
c. by logging into sqlline utility, and with command "USE TSCHEMA"
then..executing
>> CREATE TABLE command, create a table in TSCHEMA
>> CREATE VIEW, creates view in TSCHEMA
but, other DDL statments like
>> DROP TABLE
>> DROP VIEW etc. are checking for the tables/views in the default schema,
>> rather than in TSCHEMA
thereby , these DROP commands to be executed by specifying TSCHEMA.<TABLE/VIEW>
inplace of table/view.
Shoun't DROP,ALTER ddl-statements operate in the schema (TSCHEMA) provided?
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
