Hi, Thank you so much!
I am new to phoenix, could you advice where to set the JDBC connector string in Phoenix? is it in some configuration of Phoenix? regards Arthur and include the port number in the JDBC connector string: jdbc:phoenix [ :<zookeeper quorum> [:<port number > ] [ :/hbase ]] On 8 Oct, 2014, at 9:28 pm, yeshwanth kumar <[email protected]> wrote: > Hi arthur, > > its not related to hdfs or hbase path. > U need to specify the zookeper quorum > > jdbc:phoenix [ :<zookeeper quorum> [ :<port number> ] [ :<root node> ] ] > > > > -Yeshwanth > Can you Imagine what I would do if I could do all I can - Art of War > > On Wed, Oct 8, 2014 at 5:42 PM, [email protected] > <[email protected]> wrote: > 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 >
