This works fine for me
mac:bin xiaobogu$ ./psql.py lix2.bh.com:2181:/hbase-unsecure ../examples/WEB_STAT.sql ../examples/WEB_STAT.csv ../examples/WEB_STAT_QUERIES.sql SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder". SLF4J: Defaulting to no-operation (NOP) logger implementation SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. 15/06/17 17:46:50 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable no rows upserted Time: 0.939 sec(s) csv columns from database. CSV Upsert complete. 39 rows upserted Time: 0.135 sec(s) DOMAIN AVERAGE_CPU_USAGE AVERAGE_DB_USAGE ---------------------------------------- ---------------------------------------- ---------------------------------------- Salesforce.com 260.727 257.636 Google.com 212.875 213.75 Apple.com 114.111 119.556 Time: 0.069 sec(s) DAY TOTAL_CPU_USAGE MIN_CPU_USAGE MAX_CPU_USAGE ----------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- 2013-01-01 00:00:00.000 35 35 35 2013-01-02 00:00:00.000 150 25 125 2013-01-03 00:00:00.000 88 88 88 2013-01-04 00:00:00.000 26 3 23 2013-01-05 00:00:00.000 550 75 475 2013-01-06 00:00:00.000 12 12 12 2013-01-08 00:00:00.000 345 345 345 2013-01-09 00:00:00.000 390 35 355 2013-01-10 00:00:00.000 345 345 345 2013-01-11 00:00:00.000 335 335 335 2013-01-12 00:00:00.000 5 5 5 2013-01-13 00:00:00.000 355 355 355 2013-01-14 00:00:00.000 5 5 5 2013-01-15 00:00:00.000 720 65 655 2013-01-16 00:00:00.000 785 785 785 2013-01-17 00:00:00.000 1590 355 1235 Time: 0.089 sec(s) HO TOTAL_ACTIVE_VISITORS -- ---------------------------------------- EU 150 NA 1 Time: 0.068 sec(s) mac:bin xiaobogu$ ------------------ Original ------------------ From: "guxiaobo1982";<[email protected]>; Send time: Wednesday, Jun 17, 2015 12:45 PM To: "user"<[email protected]>; Subject: How to set the URL for Hbase with custom zookeeper.znode.parent Hi, I am trying to use SQuirreLSQL to connect to a remote single node HBase instance with a customed zookeeper.znode.parent /hbase-unsecure, and the hbase.zookeeper.quorum is lix2.bh.com with port 2181, then what should be the JDBC URL. The steps at http://phoenix.apache.org/installation.html#SQL_Client does not work for me, BTW the HBase instance is installed through Hortonworks HDP 2.2.4.2-2. Thanks.
