I have a create a SQL table and I am trying to import it in Sqoop. But when I run sqoop import command, I am getting the following error:
Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver
Seems like you don't have MySQL connector installed on your system. To make sqoop interact with MySQL, you have to install MySQL connector. You can install the drivers using the following command:
sudo apt-get install mysql-connector-java*
It seems you did not copy the mysql-connector jar file. You just download it and paste it to the sqoop/lib folder.
It will work.
Have you tried to put the both ...READ MORE
You need database driver in 'SQOOP' classpath ...READ MORE
You need to point the HADOOP_PREFIX to ...READ MORE
This seems like a path issue.
Add the ...READ MORE
Firstly you need to understand the concept ...READ MORE
org.apache.hadoop.mapred is the Old API
org.apache.hadoop.mapreduce is the ...READ MORE
put <localSrc> <dest>
copyFr ...READ MORE
In your case there is no difference ...READ MORE
You have to add HADOOP_CLASSPATH environment parameter:
export ...READ MORE
It looks like the path is not ...READ MORE
Already have an account? Sign in.