You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by guxiaobo1982 <gu...@qq.com> on 2015/06/17 06:45:12 UTC
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.
Re: How to set the URL for Hbase with custom zookeeper.znode.parent
Posted by guxiaobo1982 <gu...@qq.com>.
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";<gu...@qq.com>;
Send time: Wednesday, Jun 17, 2015 12:45 PM
To: "user"<us...@phoenix.apache.org>;
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.