Install PostgreSQL JDBC driver for Sqoop

0 votes
How to install PostgreSQL JDBC driver for Sqoop?
Jun 6 in Big Data Hadoop by Kanta
182 views

1 answer to this question.

0 votes

All you have to do to install PostgreSQL JDBC driver for Sqoop is download the driver and place it in the /var/lib/sqoop2/ directory. You can do this with the following commands:

$ curl -L 'http://jdbc.postgresql.org/download/postgresql-9.2-1002.jdbc4.jar' -o postgresql-9.2-1002.jdbc4.jar
$ sudo cp postgresql-9.2-1002.jdbc4.jar /var/lib/sqoop2/
answered Jun 6 by Quill

Related Questions In Big Data Hadoop

0 votes
1 answer

Specify JDBC driver to use with Sqoop

Mention the JDBC driver in the sqoop import ...READ MORE

answered May 17 in Big Data Hadoop by Kishan
83 views
0 votes
1 answer

How to set a custom install directory for a deb package with fpm

Here's something that you can try... the last ...READ MORE

answered Mar 26, 2018 in Big Data Hadoop by Amrinder
• 140 points
82 views
0 votes
1 answer
0 votes
1 answer

How to install Sqoop with Hadoop 2.2.0?

You can refer the below link to ...READ MORE

answered Sep 18, 2018 in Big Data Hadoop by Frankie
• 9,810 points
265 views
0 votes
1 answer

What is the PostgreSQL connection string for Sqoop?

The format of the connection string is: jdbc:postgresql://<HOST>:<PORT>/<DATABASE_NAME> You ...READ MORE

answered Jun 6 in Big Data Hadoop by Kamal
58 views
0 votes
1 answer

How to perform Near-real time analytics using Hadoop?

To perform Near-real time analytics, you have ...READ MORE

answered Apr 24, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
40 views
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27 in Big Data Hadoop by Omkar
• 67,600 points
35 views
0 votes
1 answer
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,600 points
262 views
0 votes
1 answer

which version of sqoop i install for hadoop3.1.1 ?

Hi @lucky! The latest version of Sqoop available ...READ MORE

answered Feb 7 in Big Data Hadoop by Omkar
• 67,600 points
488 views