[jira] [Created] (PHOENIX-3962) Not creating the table in custom schema

["vishal (JIRA)" <ji...@apache.org>]

vishal created PHOENIX-3962:
-------------------------------

             Summary: Not creating the table in custom schema
                 Key: PHOENIX-3962
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3962
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.10.0
         Environment: HBase : 1.2.6
Phoenix : 4.10.0-Hbase-1.2.0
            Reporter: vishal


I am trying to create a table MYTAB1 in my schema/namespace MYTEST.
But instead of creating the table in that namespace it is creating it in default namespace with the table name  *MYTEST.MYTAB1*.
This not my requirement.

I have done like this:
1) hbase(main):059:0> create_namespace 'MYTEST'
2)hbase(main):059:0> list_namespace_tables 'MYTEST'
   --> result will be empty as i have not created any tables

3)createing table using phoenix using sql as below:

{code:java}
connection = DriverManager.getConnection("jdbc:phoenix:localhost:12181");
statement = connection.createStatement();
statement.executeUpdate("create table *MYTEST.MYTAB1* (employee_id integer not null primary key, name varchar)");
connection.commit();
{code}

4)hbase(main):059:0> list_namespace_tables 'MYTEST'
   --> still it is returning empty.

Please suggest me the right syntax to create table in my own schema.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)