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.