Member since
11-04-2019
26
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1817 | 11-25-2019 12:30 AM |
04-13-2020
12:46 AM
hi @elkrish , Was this resolved ?? can u share if you found a solution for this issue ??
... View more
04-11-2020
12:12 PM
Hi @akv31 Point no 1 : Did u create a new java security file with new properties you want to change and place it in all nodes in a local directory or hdfs directory ??
... View more
02-08-2020
09:41 PM
@paras Thank you for your inputs. It is MSSQL database I am trying to fetch data from.( not mysql). Upgrading production database would be a difficult option at the moment. Is there a way in which I can change/override the disabled algorithm property in java security file run time in sqoop command. ?? so that i dont have to change the security file property on each node. Thanks
... View more
02-05-2020
09:44 PM
@paras Thank you .. As a work around , I commented out the disabled algorithms property in "java.security" file and tried the sqoop command and that worked. Just wanted to understand how does this work with sqoop when there is a change made in java.security file ? The above is a temporary solution and I am looking for a solution where I can change the java security file property in run time in the sqoop import command. This is because we cannot change the "java security" file on each node and affect other systems. Please share your inputs. Thanks in advance
... View more
02-05-2020
02:43 AM
Hi,
I am trying to connect to MSSQL database.
The custom jar used is sqljdbc4.jar.
Using sql server authentication with username and pwd.
versions : Sqoop version: 1.4.6-cdh5.14.2
The MSSQL database I am trying to connect is SSL enabled and I am getting the below error while using the sqoop command
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server chose TLSv1, but that protocol version is not enabled or not supported by the client.".
Is there a solution for this ?
... View more
Labels:
- Labels:
-
Apache Sqoop
-
Security
01-05-2020
09:50 PM
@Shelton Thank you for your inputs. The above shows serialize-deserializing of a file that contains images. The one I am trying is to import a column in oracle table to HDFS using sqoop. Other documentations shows mapping the column to string using --map-column-java as the solution. But the same throws error: Caused by: java.sql.SQLException: Invalid column type: getString/getNString not implemented for class oracle.jdbc.driver.T4CBlobAccessor
... View more
01-05-2020
04:46 AM
@Shelton could you please repost the solution ?? I am facing similar issue. separate thread for the same created https://community.cloudera.com/t5/Support-Questions/sqoop-import-of-BLOB-columns-from-oracle-database/m-p/286761#M212633 Thanks in advance
... View more
01-04-2020
11:33 PM
@pavan_kumar I tried with --map-column-java column_name=binary /Binary Below is the errors that i get : 20/01/05 10:04:58 ERROR tool.ImportTool: Import failed: No ResultSet method for Java type binary 20/01/05 10:04:07 ERROR tool.ImportTool: Import failed: No ResultSet method for Java type Binary i tried map-column-hive column_name=binary The sqoop import was success but when i query the table in impala it shows the below error AnalysisException: Unsupported type 'BINARY' in Table All other columns are accessible but the blob one is corrupted and hence unable to query
... View more
12-31-2019
03:34 AM
I have to import table from oracle that contains both blob and clob
--map-column-java CLOB_column=String works fine
--map-column-java BLOB_column=String throws error
How do we import blob data type columns from oracle using sqoop ?
Query used:
sqoop import --connect 'jdbc:oracle:thin:@serveri_ip:port/database' --username <> -password <> --query "SELECT * FROM table_name WHERE \$CONDITIONS" --map-column-java CMID=Integer,DATAPROP=String --as-parquetfile --delete-target-dir --target-dir /user/test/ --m 1
DATAPROP --> is the BLOB column
... View more
Labels:
- Labels:
-
Apache Sqoop