[
https://issues.apache.org/jira/browse/PHOENIX-3962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16056988#comment-16056988
]
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: 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)
