Reply
Highlighted
New Contributor
Posts: 5
Registered: ‎02-19-2018

Error Using Apache Phoenix with CDH 514

I am trying to inetrgarte apache-phoenix-4.14.1-HBase-1.2-bin with  CDH 514 and when I run the below command

from apache /....../bin dir :

./sqlline.py <zookeeper Leade host>:2181 , I am getting the below error

 

(ts a kerberized cluster) Can you please suggest what is missing here. (Apache and CDH versions are compatible)

 


Setting property: [incremental, false]
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:bdrdmaster02i2d.eur.nsroot.net:2181 none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:bdrdmaster02i2d.eur.nsroot.net:2181
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/dg27377/apache-phoenix/apache-phoenix-4.14.1-HBase-1.2-bin/phoenix-4.14.1-HBase-1.2-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-6.0.0-1.cdh6.0.0.p0.537114/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.
18/11/26 12:10:34 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
Error: Failed after attempts=36, exceptions:
Mon Nov 26 12:11:23 GMT 2018, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68533: row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=bdrdmaster03i2d.eur.nsroot.net,16020,1542646017442, seqNum=0 (state=08000,code=101)
org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=36, exceptions:
Mon Nov 26 12:11:23 GMT 2018, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68533: row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=bdrdmaster03i2d.eur.nsroot.net,16020,1542646017442, seqNum=0

at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:144)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1197)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1491)
at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2725)
at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1114)
at org.apache.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:192)
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:2536)
at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2499)
at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2499)
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 sqlline.DatabaseConnection.connect(DatabaseConnection.java:157)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
at sqlline.Commands.connect(Commands.java:1064)
at sqlline.Commands.connect(Commands.java:996)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
at sqlline.SqlLine.dispatch(SqlLine.java:809)
at sqlline.SqlLine.initArgs(SqlLine.java:588)
at sqlline.SqlLine.begin(SqlLine.java:661)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:291)
Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:
Mon Nov 26 12:11:23 GMT 2018, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68533: row 'SYSTEM:CATALOG,,' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=bdrdmaster03i2d.eur.nsroot.net,16020,1542646017442, seqNum=0

 

 

New Contributor
Posts: 5
Registered: ‎02-19-2018

Re: Error Using Apache Phoenix with CDH 6

Apologies , A small correction , the below error is testing apahe phoenix with C6

New Contributor
Posts: 5
Registered: ‎02-19-2018

Re: Error Using Apache Phoenix with CDH 6

Team

 

can some one suggest on the below error ?

Posts: 1,903
Kudos: 435
Solutions: 307
Registered: ‎07-31-2013

Re: Error Using Apache Phoenix with CDH 6

CDH6 uses Apache HBase 2.x. I notice that you are attempting to use Apache
Phoenix 4.x on it (which was built for Apache HBase 1.x versions and not
2.x, and there are incompatible changes between the two lines), have you
tried to use the recent Apache Phoenix 5.x version instead?
New Contributor
Posts: 5
Registered: ‎02-19-2018

Re: Error Using Apache Phoenix with CDH 6

Hi Harsh

 

yes I have used the Apache Phoenix 5.x version as well and getting the same error.

 

Is that some thing missing in Hbase classpath , the path of hbase-site.xml  ? I followed some blogs which says the same but could not figure where I need to do the setting? If that looks the issue can you please suggest where hbase classpath need to be set in CDH 6 ?

New Contributor
Posts: 5
Registered: ‎02-19-2018

Re: Error Using Apache Phoenix with CDH 6

I am able to proceed ahead and getting the below exception 

 

Command Used : ./sqlline.py bdqtmaster01i2d.lac.nsroot.net:2181:localhost ( I am running it from hbase server)

 

Error : 

 

org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: Unable to load configured region split policy 'org.apache.phoenix.schema.MetaDataSplitPolicy' for table 'SYSTEM.CATALOG' Set hbase.table.sanity.checks to false at conf or table descriptor if you want to bypass sanity checks

 

Can you please suggest me where we set this property in CDH 514 , I set in hbase-site.xml trestarted the hbase service and tried connecting again , I am getting the same error.

New Contributor
Posts: 2
Registered: ‎04-18-2016

Re: Error Using Apache Phoenix with CDH 6

May be it's late. I have recompiled it with 6.0.1 and with some minor changes that works with cdh6.0.1

You can download the parcel.

 

https://github.com/dmilan77/cloudera-phoenix/releases/tag/5.0.0cdh6.0.1-p1.0