phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-3962) Not creating the table in custom schema
Date Wed, 21 Jun 2017 04:51:00 GMT


Ankit Singhal commented on PHOENIX-3962:

It seems error while creating SYSTEM.MUTEX snapshot for upgrade. can you check master logs
for the similar errors as well.
I'm assuming that you are not running multiple connections when you are doing upgrade(means
during first time after enabling namespace properties). 

You can also try after deleting the snapshot if it exists (from hbase shell: list_snapshots
and delete_snapshot '_UPGRADING_TABLE_SYSTEM.MUTEX')

> Not creating the table in custom schema
> ---------------------------------------
>                 Key: PHOENIX-3962
>                 URL:
>             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

View raw message