phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From swaroopa kadam <swaroopa.kada...@gmail.com>
Subject Re: Cannot initiate connection as SYSTEM:CATALOG is found but client does not have phoenix.schema.isNamespaceMappingEnabled enabled
Date Tue, 11 Aug 2020 05:47:42 GMT
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 <ispmd@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>

Mime
View raw message