phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "vishal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3962) Not creating the table in custom schema
Date Wed, 21 Jun 2017 03:50:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16056945#comment-16056945
] 

vishal commented on PHOENIX-3962:
---------------------------------

Yes I have added in server side i.e. in hdfs-site.xml and as well as in client side i.e. in
my java program.
But every time I am getting new errors..

hdfs-site.xml
----------------

{code:java}
   <property>
	    <name>phoenix.schema.isNamespaceMappingEnabled</name>
	    <value>true</value>
   </property>

  	<property>
	    <name>phoenix.schema.mapSystemTablesToNamespace</name>
	    <value>true</value>
   </property>
{code}


java application
----------------
{code:java}
Properties connectionProps = new Properties();
connectionProps.put("phoenix.schema.isNamespaceMappingEnabled", "true");
connectionProps.put("phoenix.schema.mapSystemTablesToNamespace", "true");
connection = DriverManager.getConnection("jdbc:phoenix:localhost", connectionProps);
{code}



> 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)

Mime
View raw message