Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error Using Apache Phoenix with CDH 514

Error Using Apache Phoenix with CDH 514

New Contributor

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

 

 

6 REPLIES 6

Re: Error Using Apache Phoenix with CDH 6

New Contributor

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

Re: Error Using Apache Phoenix with CDH 6

New Contributor

Team

 

can some one suggest on the below error ?

Re: Error Using Apache Phoenix with CDH 6

Master Guru
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?

Re: Error Using Apache Phoenix with CDH 6

New Contributor

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 ?

Highlighted

Re: Error Using Apache Phoenix with CDH 6

New Contributor

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.

Re: Error Using Apache Phoenix with CDH 6

New Contributor

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