Impala cannot find com.mysql.jdbc.Driver

Question

I am trying to configure Cloudera Impala with CDH4 in pseudo-distributed mode on Red Hat 5. I have Hive using JDBC to connect to the MySQL metastar, but I am having trouble setting up Impala using JDBC. I follow the instructions given here: http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Impala/ciiu_impala_jdbc.html

I extracted the JAR into a directory and included this directory in $CLASSPATH . I also included /usr/lib/hive/lib in $CLASSPATH , which has mysql-connector-java-5.1.25-bin.jar .

In both my Yaiva and Impala conf hive-site.xml , I have hive-site.xml , including the following properties:

 <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://localhost/metastore</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>hiveuser</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>password</value> </property> <property> <name>datanucleus.autoCreateSchema</name> <value>false</value> </property> <property> <name>datanucleus.fixedDatastore</name> <value>true</value> </property> 

But when I run sudo service impala-server restart , the server log has this error:

 ERROR common.MetaStoreClientPool: Error initializing Hive Meta Store client javax.jdo.JDOFatalInternalException: Error creating transactional connection factory 

This suggests that:

 Caused by: org.datanucleus.store.rdbms.datasource.DatastoreDriverNotFoundException: The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver. at org.datanucleus.store.rdbms.datasource.dbcp.DBCPDataSourceFactory.makePooledDataSource(DBCPDataSourceFactory.java:80) at org.datanucleus.store.rdbms.ConnectionFactoryImpl.initDataSourceTx(ConnectionFactoryImpl.java:144) ... 57 more 

Is there any step that I am missing to configure Impala using JDBC?

Answer 1

I fixed this by copying mysql-connector-java-5.1.25-bin.jar to /var/lib/impala - running the script prompted the class paths to look here for a connector container for any reason.