Hi Steve, Thank you for the reply. I'm using cloudbreak and Ambari.
On Mon, Apr 25, 2016 at 7:59 PM, Steve Terrell <[email protected]> wrote: > Are you using Amazon EMR as your cluster? Are you trying to connect to > Phoenix on an EMR master or from outside the cluster? > > On Mon, Apr 25, 2016 at 8:25 AM, Asanka Sanjaya Herath <[email protected] > > wrote: > >> I'm using simple phoenix hello world program in a amazon cluster. When I >> run *./sqlline.py <zookeeper>* it connects properly. But when I use the >> java program it gives me following error. I took the >> *phoenix-4.4.0.2.3.4.0-3485-client.jar* from phoenix installation >> directory and copied it to the class path. Same zookeeper host name is used >> in both cases. >> >> 16/04/25 12:58:56 INFO zookeeper.RecoverableZooKeeper: Process >> identifier=hconnection-0x7e31ce0f connecting to ZooKeeper >> ensemble=ip-10-0-134-242:2181 >> 12:58:56.084 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:zookeeper.version=3.4.6-1569965, built on 02/20/2014 09:09 GMT >> 12:58:56.084 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:host.name=ip-10-0-125-44.ec2.internal >> 12:58:56.085 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:java.version=1.8.0_72 >> 12:58:56.085 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:java.vendor=Oracle Corporation >> 12:58:56.086 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:java.home=/usr/lib/jvm/java-8-oracle/jre >> 12:58:56.086 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:java.class.path=/home/ubuntu/batch-jobs/job-xx/target/job-xx-1.0-SNAPSHOT.jar:/home/ubuntu/phoenix-4.4.0.2.3.4.0-3485-client.jar:. >> 12:58:56.087 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib >> 12:58:56.088 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:java.io.tmpdir=/tmp >> 12:58:56.089 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:java.compiler=<NA> >> 12:58:56.090 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:os.name=Linux >> 12:58:56.091 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:os.arch=amd64 >> 12:58:56.091 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:os.version=3.13.0-74-generic >> 12:58:56.093 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:user.name=ubuntu >> 12:58:56.093 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:user.home=/home/ubuntu >> 12:58:56.094 [logback-1] INFO org.apache.zookeeper.ZooKeeper - Client >> environment:user.dir=/home/ubuntu/batch-jobs >> 12:58:56.096 [logback-1] INFO org.apache.zookeeper.ZooKeeper - >> Initiating client connection, connectString=ip-10-0-134-242:2181 >> sessionTimeout=90000 watcher=hconnection-0x7e31ce0f0x0, >> quorum=ip-10-0-134-242:2181, baseZNode=/hbase >> 12:58:56.106 [logback-1] DEBUG org.apache.zookeeper.ClientCnxn - >> zookeeper.disableAutoWatchReset is false >> 12:58:56.140 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] INFO >> org.apache.zookeeper.ClientCnxn - Opening socket connection to server >> ip-10-0-134-242.ec2.internal/10.0.134.242:2181. Will not attempt to >> authenticate using SASL (unknown error) >> 12:58:56.162 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] INFO >> org.apache.zookeeper.ClientCnxn - Socket connection established to >> ip-10-0-134-242.ec2.internal/10.0.134.242:2181, initiating session >> 12:58:56.165 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] DEBUG >> org.apache.zookeeper.ClientCnxn - Session establishment request sent on >> ip-10-0-134-242.ec2.internal/10.0.134.242:2181 >> 12:58:56.178 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] INFO >> org.apache.zookeeper.ClientCnxn - Session establishment complete on server >> ip-10-0-134-242.ec2.internal/10.0.134.242:2181, sessionid = >> 0x153df7a2df00c31, negotiated timeout = 40000 >> 12:58:56.190 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] DEBUG >> org.apache.zookeeper.ClientCnxn - Reading reply >> sessionid:0x153df7a2df00c31, packet:: clientPath:null serverPath:null >> finished:false header:: 1,3 replyHeader:: 1,17180112691,-101 request:: >> '/hbase/hbaseid,F response:: >> 16/04/25 12:58:56 INFO client.ZooKeeperRegistry: ClusterId read in >> ZooKeeper is null >> 16/04/25 12:58:56 INFO >> client.ConnectionManager$HConnectionImplementation: Closing zookeeper >> sessionid=0x153df7a2df00c31 >> 12:58:56.250 [main] DEBUG org.apache.zookeeper.ZooKeeper - Closing >> session: 0x153df7a2df00c31 >> 12:58:56.251 [main] DEBUG org.apache.zookeeper.ClientCnxn - Closing >> client for session: 0x153df7a2df00c31 >> 12:58:56.255 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] DEBUG >> org.apache.zookeeper.ClientCnxn - Reading reply >> sessionid:0x153df7a2df00c31, packet:: clientPath:null serverPath:null >> finished:false header:: 2,-11 replyHeader:: 2,17180112692,0 request:: >> null response:: null >> 12:58:56.255 [main-SendThread(ip-10-0-134-242.ec2.internal:2181)] DEBUG >> org.apache.zookeeper.ClientCnxn - An exception was thrown while closing >> send thread for session 0x153df7a2df00c31 : Unable to read additional data >> from server sessionid 0x153df7a2df00c31, likely server has closed socket >> 12:58:56.255 [main] DEBUG org.apache.zookeeper.ClientCnxn - Disconnecting >> client for session: 0x153df7a2df00c31 >> 12:58:56.256 [main-EventThread] INFO org.apache.zookeeper.ClientCnxn - >> EventThread shut down >> 12:58:56.256 [main] INFO org.apache.zookeeper.ZooKeeper - Session: >> 0x153df7a2df00c31 closed >> Exception in thread "main" java.lang.NoSuchMethodError: >> org.apache.hadoop.metrics2.lib.DefaultMetricsSystem.instance()Lorg/apache/hadoop/metrics2/MetricsSystem; >> at org.apache.phoenix.metrics.Metrics.<clinit>(Metrics.java:29) >> at >> org.apache.phoenix.trace.TraceMetricSource.<init>(TraceMetricSource.java:86) >> at >> org.apache.phoenix.trace.util.Tracing.addTraceMetricsSource(Tracing.java:269) >> at >> org.apache.phoenix.jdbc.PhoenixConnection.<clinit>(PhoenixConnection.java:146) >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1848) >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1820) >> at >> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77) >> at >> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1820) >> 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 java.sql.DriverManager.getConnection(DriverManager.java:664) >> at java.sql.DriverManager.getConnection(DriverManager.java:270) >> at >> com.xxx.xxx.core.connector.PhoenixConnector.<init>(PhoenixConnector.java:22) >> at >> com.xxx.xxx.core.connector.storage.HadoopImmutableStore.<init>(HadoopImmutableStore.java:48) >> at com.xxx.xx.job.xx.xx.main(xxxx.java:68) >> >> >> -- >> Thanks, >> Regards, >> ASH >> > > -- Thanks, Regards, ASH
