After you link phoenix-core.jar into hbase lib folder, have you restarted region server & master? To see the log from sqlline, you need to modify these two lines in log4j.properties file which is under the same folder as the sqlline.py to following:
³psql.root.logger=DEBUG,console log4j.threshold=DEBUG² In addition, it¹s better that you start sqlline from phoenix bin folder. From: Poonam Ligade <[email protected]> Reply-To: <[email protected]> Date: Monday, September 8, 2014 at 10:26 AM To: <[email protected]> Subject: phoenix sqlline not working on hortonworks + ubuntu 12.4 Hi , I have installed hortonworks hadoop 2.1 on ubuntu12.4 manually. hadoop version 2.4.0.2.1.3.0-563 hbase version 0.98.0.2.1.3.0-563-hadoop2 I have added symlinks to phoenix-core-4.0.0.2.1.3.0-563.jar inside /hbase/lib as well as phoenix-client.jar added symlinks for core-site.xml and hbase-site.xml in phoenix/bin when I am trying to connect to sqlline sqlline.py zookeeper.quoram:2181:/hbase-unsecure. It just hangs after printing this. Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:localhost:2181:/hbase-unsecure none none org.apache.phoenix.jdbc.PhoenixDriver Connecting to jdbc:phoenix:localhost:2181:/hbase-unsecure 14/09/08 10:22:23 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable and doesn't come out until I kill it Where should I check phoenix logs? Any pointers? Thanks, Poonam. -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
