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>
