phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <josh.el...@gmail.com>
Subject Re: using MapReduce java.sql.SQLException: No suitable driver found for jdbc:phoenix occured.
Date Wed, 14 Sep 2016 23:59:37 GMT
phoenix-4.8.0-HBase-1.1-client.jar is the jar which should be used. The 
phoenix-4.8.0-HBase-1.1-hive.jar is to be used with the Hive integration.

dalin.qin wrote:
> [root@namenode phoenix]# findjar . org.apache.phoenix.jdbc.PhoenixDriver
> Starting search for JAR files from directory .
> Looking for the class org.apache.phoenix.jdbc.PhoenixDriver
>
> This might take a while...
>
> ./phoenix-4.8.0-HBase-1.1-client.jar
> ./phoenix-4.8.0-HBase-1.1-server.jar
> ./phoenix-4.8.0-HBase-1.1-hive.jar
> ./phoenix-core-4.8.0-HBase-1.1-tests.jar
> ./phoenix-core-4.8.0-HBase-1.1.jar
> ./phoenix-core-4.8.0-HBase-1.1-sources.jar
>
> add phoenix-4.8.0-HBase-1.1-client.jar
> or phoenix-4.8.0-HBase-1.1-hive.jar(I'm not quite sure which one, you
> might try ) to your classpath might solve your problem .
>
> On Tue, Sep 13, 2016 at 7:05 AM, Dong-iL, Kim <kim.same@gmail.com
> <mailto:kim.same@gmail.com>> wrote:
>
>     Hi.
>     I've tested the map reduce code on homepage.
>     It coudln’t find the jdbc driver as below.
>     I've insert this code
>     "Class.forName("org.apache.phoenix.jdbc.PhoenixDriver”);" in mred
>     main method but there is no effect.
>     What shall I do?
>     Regards.
>
>
>     Error: java.lang.RuntimeException: java.sql.SQLException: No
>     suitable driver found for
>     jdbc:phoenix:internal.hadoop-master.denma.ggportal.net:2181
>     <http://master.denma.ggportal.net:2181>:/hbase;
>          at
>     org.apache.phoenix.mapreduce.PhoenixInputFormat.getQueryPlan(PhoenixInputFormat.java:134)
>          at
>     org.apache.phoenix.mapreduce.PhoenixInputFormat.createRecordReader(PhoenixInputFormat.java:71)
>          at
>     org.apache.hadoop.mapred.MapTask$NewTrackingRecordReader.<init>(MapTask.java:524)
>          at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:767)
>          at org.apache.hadoop.mapred.MapTask.run(MapTask.java:342)
>          at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)
>          at java.security.AccessController.doPrivileged(Native Method)
>          at javax.security.auth.Subject.doAs(Subject.java:422)
>          at
>     org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
>          at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
>     Caused by: java.sql.SQLException: No suitable driver found for
>     jdbc:phoenix:internal.hadoop-master.denma.ggportal.net:2181
>     <http://master.denma.ggportal.net:2181>:/hbase;
>          at java.sql.DriverManager.getConnection(DriverManager.java:689)
>          at java.sql.DriverManager.getConnection(DriverManager.java:208)
>          at
>     org.apache.phoenix.mapreduce.util.ConnectionUtil.getConnection(ConnectionUtil.java:98)
>          at
>     org.apache.phoenix.mapreduce.util.ConnectionUtil.getInputConnection(ConnectionUtil.java:57)
>          at
>     org.apache.phoenix.mapreduce.PhoenixInputFormat.getQueryPlan(PhoenixInputFormat.java:116)
>          ... 9 more
>
>

Mime
View raw message