Hi,
I've installed Phoenix 3.1.0 on Amazon EMR but the command "./sqlline.py
localhost" just hangs with following output. Any thoughts on what I'm
missing?
Here is related info:
*Phoenix 3.1.0*
*HBase 0.94.18*
*Amazon Hadoop 2.4.0*
*Phoenix core:*
/home/hadoop/.versions/hbase-0.94.18/lib/phoenix-core-3.1.0.jar
*Phoenix client:*
/home/hadoop/.versions/hbase-0.94.18/lib/phoenix/phoenix-3.1.0-client-hadoop2.jar
*hbase-site.xml:*
/home/hadoop/.versions/hbase-0.94.18/lib/phoenix/bin/hbase-site.xml
*$> ./sqlline.py localhost*
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost
14/09/09 21:24:17 WARN conf.Configuration: dfs.df.interval is deprecated.
Instead, use fs.df.interval
14/09/09 21:24:17 WARN conf.Configuration: hadoop.native.lib is deprecated.
Instead, use io.native.lib.available
14/09/09 21:24:17 WARN conf.Configuration: fs.default.name is deprecated.
Instead, use fs.defaultFS
14/09/09 21:24:17 WARN conf.Configuration: topology.script.number.args is
deprecated. Instead, use net.topology.script.number.args
14/09/09 21:24:17 WARN conf.Configuration: dfs.umaskmode is deprecated.
Instead, use fs.permissions.umask-mode
14/09/09 21:24:17 WARN conf.Configuration:
topology.node.switch.mapping.impl is deprecated. Instead, use
net.topology.node.switch.mapping.impl
14/09/09 21:24:18 WARN conf.Configuration: fs.default.name is deprecated.
Instead, use fs.defaultFS
14/09/09 21:24:18 DEBUG zookeeper.ZKUtil: hconnection opening connection to
ZooKeeper with ensemble (localhost:2181)
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:zookeeper.version=3.4.5-1392090, built on 09/30/2012 17:52 GMT
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client environment:host.name
=ip-172-31-43-176.us-west-2.compute.internal
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:java.version=1.7.0_65
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:java.vendor=Oracle Corporation
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:java.home=/usr/java/jdk1.7.0_65/jre
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:java.class.path=.:/home/hadoop/.versions/hbase-0.94.18/lib/phoenix/bin/../phoenix-3.1.0-client-hadoop2.jar
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:java.library.path=/home/hadoop/lib/native:/usr/lib64:/usr/local/cuda/lib64:/usr/local/cuda/lib::/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:java.io.tmpdir=/tmp
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:java.compiler=<NA>
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client environment:os.name=Linux
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client environment:os.arch=amd64
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:os.version=3.4.76-65.111.amzn1.x86_64
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client environment:user.name
=hadoop
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:user.home=/home/hadoop
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Client
environment:user.dir=/home/hadoop/.versions/hbase-0.94.18/lib/phoenix/bin
14/09/09 21:24:18 INFO zookeeper.ZooKeeper: Initiating client connection,
connectString=localhost:2181 sessionTimeout=180000 watcher=hconnection
14/09/09 21:24:18 DEBUG zookeeper.ClientCnxn:
zookeeper.disableAutoWatchReset is false
14/09/09 21:24:18 INFO zookeeper.RecoverableZooKeeper: The identifier of
this process is 1...@ip-172-31-43-176.us-west-2.compute.internal
14/09/09 21:24:18 INFO zookeeper.ClientCnxn: Opening socket connection to
server localhost/127.0.0.1:2181. Will not attempt to authenticate using
SASL (unknown error)
14/09/09 21:24:19 INFO zookeeper.ClientCnxn: Socket connection established
to localhost/127.0.0.1:2181, initiating session
14/09/09 21:24:19 DEBUG zookeeper.ClientCnxn: Session establishment request
sent on localhost/127.0.0.1:2181
14/09/09 21:24:19 INFO zookeeper.ClientCnxn: Session establishment complete
on server localhost/127.0.0.1:2181, sessionid = 0x1485c2742cf0026,
negotiated timeout = 180000
14/09/09 21:24:19 DEBUG zookeeper.ClientCnxn: Reading reply
sessionid:0x1485c2742cf0026, packet:: clientPath:null serverPath:null
finished:false header:: 1,3 replyHeader:: 1,203,0 request::
'/hbase/hbaseid,F response::
s{43,43,1410295441753,1410295441753,0,0,0,0,89,0,43}
14/09/09 21:24:19 DEBUG zookeeper.ClientCnxn: Reading reply
sessionid:0x1485c2742cf0026, packet:: clientPath:null serverPath:null
finished:false header:: 2,4 replyHeader:: 2,203,0 request::
'/hbase/hbaseid,F response::
#ffffffff00030333838344069702d3137322d33312d34332d3137362e75732d776573742d322e636f6d707574652e696e7465726e616c63326534333830622d303230352d343838662d383832352d616561336564366237643231,s{43,43,1410295441753,1410295441753,0,0,0,0,89,0,43}
14/09/09 21:24:19 DEBUG zookeeper.ZKUtil: hconnection-0x1485c2742cf0026
Retrieved 36 byte(s) of data from znode /hbase/hbaseid;
data=c2e4380b-0205-488f-8825-aea3e...
14/09/09 21:24:19 DEBUG zookeeper.ClientCnxn: Reading reply
sessionid:0x1485c2742cf0026, packet:: clientPath:null serverPath:null
finished:false header:: 3,3 replyHeader:: 3,203,0 request::
'/hbase/master,T response::
s{38,38,1410295432736,1410295432736,0,0,0,92425116055437323,118,0,38}
14/09/09 21:24:19 DEBUG zookeeper.ZKUtil: hconnection-0x1485c2742cf0026 Set
watcher on existing znode /hbase/master
14/09/09 21:24:19 DEBUG zookeeper.ClientCnxn: Reading reply
sessionid:0x1485c2742cf0026, packet:: clientPath:null serverPath:null
finished:false header:: 4,4 replyHeader:: 4,203,0 request::
'/hbase/master,T response::
#ffffffff00030333838344069702d3137322d33312d34332d3137362e75732d776573742d322e636f6d707574652e696e7465726e616c0069702d3137322d33312d34332d3137362e75732d776573742d322e636f6d707574652e696e7465726e616c2c36303030302c31343130323935343239373035,s{38,38,1410295432736,1410295432736,0,0,0,92425116055437323,118,0,38}
14/09/09 21:24:19 DEBUG zookeeper.ZKUtil: hconnection-0x1485c2742cf0026
Retrieved 65 byte(s) of data from znode /hbase/master and set watcher;
\x00\x00ip-172-31-43-176.us-w...
14/09/09 21:24:19 DEBUG zookeeper.ClientCnxn: Reading reply
sessionid:0x1485c2742cf0026, packet:: clientPath:null serverPath:null
finished:false header:: 5,3 replyHeader:: 5,203,0 request::
'/hbase/root-region-server,T response::
s{65,65,1410295448792,1410295448792,0,0,0,0,116,0,65}
14/09/09 21:24:19 DEBUG zookeeper.ZKUtil: hconnection-0x1485c2742cf0026 Set
watcher on existing znode /hbase/root-region-server
14/09/09 21:24:19 DEBUG zookeeper.ClientCnxn: Reading reply
sessionid:0x1485c2742cf0026, packet:: clientPath:null serverPath:null
finished:false header:: 6,4 replyHeader:: 6,203,0 request::
'/hbase/root-region-server,T response::
#ffffffff00030323431324069702d3137322d33312d34332d3133312e75732d776573742d322e636f6d707574652e696e7465726e616c69702d3137322d33312d34332d3133312e75732d776573742d322e636f6d707574652e696e7465726e616c2c36303032302c31343130323935333539323439,s{65,65,1410295448792,1410295448792,0,0,0,0,116,0,65}
14/09/09 21:24:19 DEBUG zookeeper.ZKUtil: hconnection-0x1485c2742cf0026
Retrieved 63 byte(s) of data from znode /hbase/root-region-server and set
watcher; ip-172-31-43-131.us-west-2.co...
14/09/09 21:24:19 DEBUG zookeeper.ClientCnxn: Reading reply
sessionid:0x1485c2742cf0026, packet:: clientPath:null serverPath:null
finished:false header:: 7,3 replyHeader:: 7,203,0 request:: '/hbase,F
response:: s{18,18,1410295430285,1410295430285,0,12,0,0,0,12,65}
