Sqoop could not load db driver class

0 votes

I am trying to connect postgres with sqoop

Sqoop version 1.4.6-cdh5.14.2

With command

sqoop list-tables --connect jdbc:postgresql://120.4.99.798:portnumber/db --driver org.postgresql.Driver --connection-manager org.apache.sqoop.manager.GenericJdbcManager --username user --password p

But I am getting

could not load db driver class org.apache.Driver error

But JDBC jar is present in /var/lib/sqoop2

Oct 25 in Big Data Hadoop by Ritu
• 120 points

edited Oct 25 by Ritu 53 views
The command looks good. Download the driver again and try again. In my case, I was facing this error because the driver was corrupted.

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Big Data Hadoop

0 votes
1 answer

Sqoop: java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver

Seems like you don't have MySQL connector ...READ MORE

answered Jan 28 in Big Data Hadoop by Omkar
• 67,660 points
322 views
0 votes
1 answer

Sqoop: Could not load mysql driver exception.

You need database driver in 'SQOOP' classpath ...READ MORE

answered Oct 8, 2018 in Big Data Hadoop by Frankie
• 9,810 points
893 views
0 votes
1 answer

Hadoop Mapreduce: Error: Could not find or load main class com.sun.tools.javac.Main

You have to add HADOOP_CLASSPATH environment parameter: export ...READ MORE

answered Oct 30, 2018 in Big Data Hadoop by Omkar
• 67,660 points
490 views
0 votes
1 answer

Hadoop MacOS: formatting namenode: Could not find or load main class

You need to point the HADOOP_PREFIX to ...READ MORE

answered Nov 13, 2018 in Big Data Hadoop by Omkar
• 67,660 points
137 views
0 votes
1 answer

Hadoop: Error: Could not find or load main class org.apache.hadoop.util.VersionInfo

This seems like a path issue. Add the ...READ MORE

answered Nov 16, 2018 in Big Data Hadoop by Omkar
• 67,660 points
2,525 views
0 votes
1 answer

Hadoop: Error: Could not find or load main class com.sun.tools.javac.Main

It looks like the path is not ...READ MORE

answered Nov 29, 2018 in Big Data Hadoop by Omkar
• 67,660 points
710 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,730 points
3,370 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,730 points
405 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
16,729 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
1,221 views