Does sqoop 1.4.6 version on HDP 2.6.4 support SSL

+1 vote
Hi Team,

We have an audit requirement to enable ssl in our sqoop jobs. Our source which DB2 has enabled ssl, and when trying to connect to the DB fails with below error:

"Error executing statement: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][3.68.61] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected.  Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009"

Have performed the following actions:

added the certification to keystore file and generated a .jks file

sqoop config file has the following entries:

jdbc:db2://xxxxx.xxx:60542/abcd:sslconnection=true;ssltrustStoreLocation=/tmp/truststore.jks;ssltruststorePassword=xxxx;

I have also tried adding the jks file to hdfs location but fails with "file not found exception"

Are there any config changes that needs to be made sqoop properties file?

Is there is a documentation on how ssl is implemented for sqoop 1.4.6

Thanks for the the input!!!!
Jan 28 in Big Data Hadoop by sudi
• 130 points
48 views

1 answer to this question.

0 votes
Hi,

Is your "JDBC location" string connect?  If not, then you must specify a string connect because that describe how to connect to database.
answered Jan 29 by Roshan

Related Questions In Big Data Hadoop

0 votes
1 answer

How to upgrade Apache Hadoop from 2.4.1 to 2.6.0?

If the downtime is not an issue, ...READ MORE

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

How to Upgrade Apache Hadoop from 2.4.1 to 2.6.0

If the downtime is not an issue, ...READ MORE

answered Nov 30, 2018 in Big Data Hadoop by Frankie
• 9,810 points
181 views
0 votes
1 answer

Could not find the Sqoop directory in HDP 2.2

You can find the Sqoop lib directory ...READ MORE

answered May 4, 2018 in Big Data Hadoop by Shubham
• 13,370 points
327 views
0 votes
1 answer

I want to install snappy on Hadoop 1.2.1. How do I do that?

As per Cloudera, if you install hadoop ...READ MORE

answered Dec 11, 2018 in Big Data Hadoop by Frankie
• 9,810 points
135 views
+1 vote
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,840 points
4,131 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,840 points
582 views
+1 vote
11 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
22,305 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,310 points
1,551 views
0 votes
1 answer

How to decrease load on HBase while importing Sqoop?

Sqoop by default serializes all the input ...READ MORE

answered May 16, 2019 in Big Data Hadoop by Yogi
75 views
0 votes
1 answer

Unable to run Name node and datanode on Single Node cluster: Does not contain a valid host:port

Add the following properties in the core-site.xml file, it ...READ MORE

answered May 22, 2019 in Big Data Hadoop by Sanam
91 views