You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "vishal (JIRA)" <ji...@apache.org> on 2017/06/21 03:53:00 UTC
[jira] [Updated] (PHOENIX-3962) Not creating the table in custom
schema
[ https://issues.apache.org/jira/browse/PHOENIX-3962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
vishal updated PHOENIX-3962:
----------------------------
Description:
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");
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.
was:
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.
> 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");
> 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)