Hi,
I use Hadoop 2.4.1 Cluster and HBase Cluster (0.98.6), my HBASE rootdir is
hdfs://my_cluster/hbase
hbase-site.xml
<property>
<name>hbase.rootdir</name>
<value>hdfs://my_cluster/hbase</value>
</property>
hdfs-site.xml
<property>
<name>dfs.nameservices</name>
<value>my_cluster</value>
<final>true</final>
</property>
The hbase shell works well, when I tired Phoenix I got the following error:
./sqlline.py z1:2181,z2:2181,z3:2181:/my_cluster/hbase
Error: ERROR 102 (08001): Malformed connection url.
jdbc:phoenix:z1:2181,z2:2181,z3:2181:/my_cluster/hbase (state=08001,code=102)
java.sql.SQLException: ERROR 102 (08001): Malformed connection url.
jdbc:phoenix:z1:2181,z2:2181,z3:2181:/my_cluster/hbase
at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:333)
at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver$ConnectionInfo.getMalFormedUrlException(PhoenixEmbeddedDriver.java:183)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver$ConnectionInfo.create(PhoenixEmbeddedDriver.java:238)
at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:144)
at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
at sqlline.SqlLine.dispatch(SqlLine.java:817)
at sqlline.SqlLine.initArgs(SqlLine.java:633)
at sqlline.SqlLine.begin(SqlLine.java:680)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)
sqlline version 1.1.2
list;
No current connection
Question: What should be the correct connection URL if it is Hadoop2 and in HA
Cluster mode?
Regards
Arthur