Hi, I have managed to resolve the issue.
Regards Arthur On 9 Oct, 2014, at 7:34 am, [email protected] <[email protected]> wrote: > 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 >> >
