You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Zhou Zach <is...@foxmail.com> on 2020/08/11 04:40:31 UTC

Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled

Hi all,
&nbsp; &nbsp; When I run the code, I got a error:
HBASE_CLASSPATH_PREFIX=/opt/cloudera/parcels/PHOENIX/lib/phoenix/lib/*:/etc/hbase/conf \ &gt; /opt/cloudera/parcels/CDH/lib/hbase/bin/hbase org.apache.phoenix.mapreduce.index.IndexTool \ &gt; --schema ods --data-table USER_FLINK8 --index-table user_flink8_ctime_idx --output-path hdfs://nameservice1/phoenixSLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/lib/hbase/lib/hbase-hbck2-1.1.0-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/jars/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] 11:56:08.182 [main] INFO  org.apache.phoenix.query.ConnectionQueryServicesImpl - An instance of ConnectionQueryServices was created. 11:56:08.536 [main] INFO  org.apache.phoenix.query.ConnectionQueryServicesImpl - HConnection established. Stacktrace for informational purposes: hconnection-0x18cebaa5 java.lang.Thread.getStackTrace(Thread.java:1559) org.apache.phoenix.util.LogUtil.getCallerStackTrace(LogUtil.java:55) org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:433) org.apache.phoenix.query.ConnectionQueryServicesImpl.access$400(ConnectionQueryServicesImpl.java:273) org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2557) org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2533) org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76) org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2533) org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255) org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150) org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221) java.sql.DriverManager.getConnection(DriverManager.java:664) java.sql.DriverManager.getConnection(DriverManager.java:208) org.apache.phoenix.mapreduce.util.ConnectionUtil.getConnection(ConnectionUtil.java:113) org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:58) org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:46) org.apache.phoenix.mapreduce.index.IndexTool.run(IndexTool.java:536) org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90) org.apache.phoenix.mapreduce.index.IndexTool.main(IndexTool.java:769) 11:56:09.652 [main] ERROR org.apache.phoenix.mapreduce.index.IndexTool - An exception occurred while performing the indexing job: SQLException: ERROR 726 (43M10):  Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled at: java.sql.SQLException: ERROR 726 (43M10):  Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled 	at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:497) 	at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150) 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1114) 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1502) 	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2721) 	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1114) 	at org.apache.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:198) 	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408) 	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391) 	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) 	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390) 	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378) 	at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1806) 	at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2570) 	at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2533) 	at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76) 	at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2533) 	at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255) 	at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150) 	at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221) 	at java.sql.DriverManager.getConnection(DriverManager.java:664) 	at java.sql.DriverManager.getConnection(DriverManager.java:208) 	at org.apache.phoenix.mapreduce.util.ConnectionUtil.getConnection(ConnectionUtil.java:113) 	at org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:58) 	at org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:46) 	at org.apache.phoenix.mapreduce.index.IndexTool.run(IndexTool.java:536) 	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) 	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90) 	at org.apache.phoenix.mapreduce.index.IndexTool.main(IndexTool.java:769)


I have&nbsp;enabled&nbsp;phoenix.schema.isNamespaceMappingEnabled  in /etc/hbase/conf/hbase-site.xml
Please give me some advice，Thanks

Re: Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled

Posted by swaroopa kadam <sw...@gmail.com>.

Hi,

You will also need to make the client side change for namespace enabled
property. The config file is in same location as sqlline.py
(Phoenix/bin/hbase-site.xml)

Hope this helps.

On Mon, Aug 10, 2020 at 9:42 PM Zhou Zach <is...@foxmail.com> wrote:

> Hi all,
>     When I run the code, I got a error:
>
>
>
> *HBASE_CLASSPATH_PREFIX=/opt/cloudera/parcels/PHOENIX/lib/phoenix/lib/*:/etc/hbase/conf \> /opt/cloudera/parcels/CDH/lib/hbase/bin/hbase org.apache.phoenix.mapreduce.index.IndexTool \> --schema ods --data-table USER_FLINK8 --index-table user_flink8_ctime_idx --output-path hdfs://nameservice1/phoenix*
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> *SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/lib/hbase/lib/hbase-hbck2-1.1.0-SNAPSHOT.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/jars/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings <http://www.slf4j.org/codes.html#multiple_bindings> for an explanation.SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]11:56:08.182 [main] INFO  org.apache.phoenix.query.ConnectionQueryServicesImpl - An instance of ConnectionQueryServices was created.11:56:08.536 [main] INFO  org.apache.phoenix.query.ConnectionQueryServicesImpl - HConnection established. Stacktrace for informational purposes: hconnection-0x18cebaa5 java.lang.Thread.getStackTrace(Thread.java:1559)org.apache.phoenix.util.LogUtil.getCallerStackTrace(LogUtil.java:55)org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:433)org.apache.phoenix.query.ConnectionQueryServicesImpl.access$400(ConnectionQueryServicesImpl.java:273)org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2557)org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2533)org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2533)org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150)org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)java.sql.DriverManager.getConnection(DriverManager.java:664)java.sql.DriverManager.getConnection(DriverManager.java:208)org.apache.phoenix.mapreduce.util.ConnectionUtil.getConnection(ConnectionUtil.java:113)org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:58)org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:46)org.apache.phoenix.mapreduce.index.IndexTool.run(IndexTool.java:536)org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90)org.apache.phoenix.mapreduce.index.IndexTool.main(IndexTool.java:769)11:56:09.652 [main] ERROR org.apache.phoenix.mapreduce.index.IndexTool - An exception occurred while performing the indexing job: SQLException: ERROR 726 (43M10):  Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled at:java.sql.SQLException: ERROR 726 (43M10):  Inconsistent namespace mapping properties. Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled	at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:497)	at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)	at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1114)	at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1502)	at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2721)	at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1114)	at org.apache.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:198)	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:408)	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:391)	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:390)	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:378)	at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1806)	at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2570)	at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2533)	at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)	at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2533)	at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)	at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:150)	at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221)	at java.sql.DriverManager.getConnection(DriverManager.java:664)	at java.sql.DriverManager.getConnection(DriverManager.java:208)	at org.apache.phoenix.mapreduce.util.ConnectionUtil.getConnection(ConnectionUtil.java:113)	at org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:58)	at org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:46)	at org.apache.phoenix.mapreduce.index.IndexTool.run(IndexTool.java:536)	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:90)	at org.apache.phoenix.mapreduce.index.IndexTool.main(IndexTool.java:769)*
>
>
> I have *enabled* *phoenix.schema.isNamespaceMappingEnabled in
> /etc/hbase/conf/hbase-site.xml*
>
> Please give me some advice，Thanks
>
> --


Swaroopa Kadam
[image: https://]about.me/swaroopa_kadam
<https://about.me/swaroopa_kadam?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=gmail_api>