Hi,
The trailing semi-colon on the URL seems odd, but I do not think it
would cause issues in parsing when inspecting the logic in
PhoenixEmbeddedDriver#acceptsURL(String).
Does the Class.forName(..) call succeed? You have Phoenix properly on
the classpath for your mappers?
Dong-iL, Kim 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
