hi,   Were you able to find a solution for this ?   ... View more

hi @elkrish ,   Was this resolved ?? can u share if you found a solution for this issue ??   ... View more

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

@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

@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

@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

@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

@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