[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.s...@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:/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:/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
>
>
