Hi Murugesan, What preconditions would I need on the server to execute the python script? I have Python 2.7.5 installed on the zookeeper server. If I just copy the sqlline script to the /etc/hbase/conf directory and execute it I get the below import errors. Note this time I had 4.5.2-HBase-1.0 version server and core phoenix jars in HBase/lib directory on the master and region servers.
Traceback (most recent call last): File "./sqlline.py", line 25, in <module> import phoenix_utils ImportError: No module named phoenix_utils Pardon me for my knowledge about python. Thanks, Amit On Fri, Feb 26, 2016 at 11:26 PM, Murugesan, Rani <ranmu...@visa.com> wrote: > Did you test and confirm your phoenix shell from the zookeeper server? > > cd /etc/hbase/conf > > > phoenix-sqlline.py <zookeeperserver>:2181 > > > > > > *From:* Amit Shah [mailto:amits...@gmail.com] > *Sent:* Friday, February 26, 2016 4:45 AM > *To:* user@phoenix.apache.org > *Subject:* HBase Phoenix Integration > > > > Hello, > > > > I have been trying to install phoenix on my cloudera hbase cluster. > Cloudera version is CDH5.5.2 while HBase version is 1.0. > > > > I copied the server & core jar (version 4.6-HBase-1.0) on the master and > region servers and restarted the hbase cluster. I copied the corresponding > client jar on my SQuirrel client but I get an exception on connect. Pasted > below. The connection url is “jdbc:phoenix:<zookeeper-server-name>:2181". > > I even tried compiling the source by adding cloudera dependencies as > suggested on this post > <http://stackoverflow.com/questions/31849454/using-phoenix-with-cloudera-hbase-installed-from-repo>but > didn't succeed. > > > > Any suggestions to make this work? > > > > Thanks, > > Amit. > > > > ________________________________________________________________ > > > > Caused by: > org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apache.hadoop.hbase.DoNotRetryIOException): > org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG: > org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; > > at > org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:87) > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1319) > > at > org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:11715) > > at > org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7388) > > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1776) > > at > org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1758) > > at > org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32209) > > at > org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2034) > > at > org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107) > > at > org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130) > > at > org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107) > > at java.lang.Thread.run(Thread.java:745) > > Caused by: java.lang.NoSuchMethodError: > org.apache.hadoop.hbase.client.Scan.setRaw(Z)Lorg/apache/hadoop/hbase/client/Scan; > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildDeletedTable(MetaDataEndpointImpl.java:1016) > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.loadTable(MetaDataEndpointImpl.java:1092) > > at > org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:1266) > > ... 10 more > > > > P.S - The full stacktrace is attached in the mail. >