Install PostgreSQL JDBC driver for Sqoop

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

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
14 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
50 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,710 points
192 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
14 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
32 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
• 66,880 points
18 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
• 66,880 points
88 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
• 66,880 points
171 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.