Reply
Posts: 354
Topics: 162
Kudos: 61
Solutions: 27
Registered: ‎06-26-2013

Re: CDH Supported Phoenix

Yes:

http://blog.cloudera.com/blog/2015/11/new-apache-phoenix-4-5-2-package-from-cloudera-labs/

(Note: Labs projects are not supported, just packaged.)
New Contributor
Posts: 7
Registered: ‎01-07-2014

Re: CDH Supported Phoenix

We are trying to test Phoenix in CDH 5.7? I know the new packages are for 5.5, but do you think they should work for 5.7?

 

cd /etc/hbase/conf

phoenix-sqlline.py localhost:2181:/hbase


Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost:2181:/hbase none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost:2181:/hbase
16/05/09 15:26:15 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
16/05/09 15:26:15 WARN shortcircuit.DomainSocketFactory: The short-circuit local reads feature cannot be used because libhadoop cannot be loaded.
16/05/09 15:26:15 WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties
16/05/09 15:26:16 WARN ipc.CoprocessorRpcChannel: Call failed on IOException
org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG: org.apache.hadoop.hbase.coprocessor.RegionCoprocessorEnvironment.getRegion()Lorg/apache/hadoop/hbase/regionserver/HRegion;
at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1266)
at org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:11619)
at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7789)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1988)
at org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1970)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:33652)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2170)
at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:109)
at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:133)
at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:108)
at java.lang.Thread.run(Thread.java:745)

 

Thanks.

 

Cloudera Employee
Posts: 7
Registered: ‎09-18-2013

Re: CDH Supported Phoenix

The current CLabs phoenix that works against C5.5 will likely fail. We are in the process of creating a new Cloudera Labs version of Phoenix that is compatible with the C5.7 line.  

 

Jon.

Jonathan Hsieh (shay)
Software Engineer, Cloudera
New Contributor
Posts: 7
Registered: ‎01-07-2014

Re: CDH Supported Phoenix

Thank you.
New Contributor
Posts: 8
Registered: ‎02-03-2016

Re: CDH Supported Phoenix

Any idea when will this new Phoenix version be available for CDH 5.7?

uzi
Explorer
Posts: 13
Registered: ‎05-27-2016

Re: CDH Supported Phoenix

I am trying to run Phoenix 4.5.2 on CDH 5.7. I successfully installed it thorough parcels, but I am having issue starting it. 

It is giving me this error:

 

Error: SYSTEM.CATALOG (state=08000,code=101)
org.apache.phoenix.exception.PhoenixIOException: SYSTEM.CATALOG
at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1051)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1014)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1259)
at org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:113)
at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1937)
at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:751)
at org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:320)
at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:312)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:310)
at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1422)
at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1927)
at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1896)
at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1896)
at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:180)
at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:132)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:151)
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:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:804)
at sqlline.SqlLine.initArgs(SqlLine.java:588)
at sqlline.SqlLine.begin(SqlLine.java:656)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.CATALOG
at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1297)
at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1125)
at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1109)
at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1066)
at org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:901)
at org.apache.hadoop.hbase.client.HTable.getRegionLocation(HTable.java:558)
at org.apache.hadoop.hbase.client.HTable.getKeysAndRegionsInRange(HTable.java:817)
at org.apache.hadoop.hbase.client.HTable.getKeysAndRegionsInRange(HTable.java:787)
at org.apache.hadoop.hbase.client.HTable.getStartKeysInRange(HTable.java:1830)
at org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1785)
at org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1765)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1034)
... 32 more

 

Please let me knwo if any of you have any suggestions. It says 'SYSTEM.CATALOG' table not found. I checked and the table exists in path /hbase/data/default/SYSTEM.CATALOG' but path for hbase root dir is different and there is no SYSTEM tables on that path. I tried changing the hbase root dir path to the path wehre CATALOG table exists but no luck with that either.

Posts: 354
Topics: 162
Kudos: 61
Solutions: 27
Registered: ‎06-26-2013

Re: CDH Supported Phoenix

uzi,

 

The Phoenix 4.5.2 parcel is not designed for/was not tested on CDH 5.7, so no surprise. A new parcel for 5.7 is under consideration.

uzi
Explorer
Posts: 13
Registered: ‎05-27-2016

Re: CDH Supported Phoenix

Thnak You for your quick reply.

 

We are running Phoenix 4.5.2 on CDH 5.6, and it is running fine (apart from some connection issue when combining phoenix with spark application). I want to run phoenix on CDH 5.7 as well, do you have any suggestions on how I can make this happen, or what version of phoenix will suit better. I am aware that these things are still on research phase, but I also do not want to downgrade 5.7 to 5.6 to have phoenix.

Posts: 354
Topics: 162
Kudos: 61
Solutions: 27
Registered: ‎06-26-2013

Re: CDH Supported Phoenix

I think you'll see a new parcel for 5.7 pretty soon. Please stand by...

Highlighted
Cloudera Employee
Posts: 88
Registered: ‎01-08-2014

Re: CDH Supported Phoenix

Announcements

Currently incubating in Cloudera Labs:

Envelope
HTrace
Ibis
Impyla
Livy
Oryx
Phoenix
Spark Runner for Beam SDK
Time Series for Spark
YCSB