Member since
11-04-2019
26
Posts
1
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
880 | 11-25-2019 12:30 AM |
01-27-2021
01:54 AM
@sow I am also having the same issue, did you get any resolution for this issue?
... View more
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-12-2020
04:24 AM
Yes, I created a new java.security file with required properties and placed in all nodes in local directory.
... View more
04-11-2020
03:19 AM
Hi,
NOTE:- Parquet is hard coded to write the temporary data in /tmp even though the target directory is different.
Kindly check /tmp for intermediate data, you will see it there.
Regards
... 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
11-27-2019
04:29 AM
@EricL I tried -map-column-java Settings=String and got the data type as string in hive. however the data doesnt look corrupted but the hexadecimal representation of the value is not retained cmd used : sqoop import --driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver' --connect <> --connection-manager 'org.apache.sqoop.manager.SQLServerManager' --username <> -password <> --table 'my_table' --as-parquetfile --delete-target-dir --target-dir /user/test/ -map-column-java Settings=String --m 1 Result of above query: column data type in source : image column value in source : 0xFFffDeDJBF.......dDf. --> ( A hexadecimal value ) column data type in hive: string column value in hive: FFffDeDJBF.......dDf (0x is not retained)
... View more
11-25-2019
04:08 AM
@pmohan Does this help with columns having data type - image ?? converting the image data type to binary again is leading to data corruption. Please see the issue highlighted below : https://community.cloudera.com/t5/Support-Questions/SQOOP-import-of-quot-image-quot-data-type-into-hive/td-p/283584
... View more
11-25-2019
12:30 AM
1 Kudo
using the query option helped. solution : sqoop import --connect <> --username <> -password <> --as-parquetfile --delete-target-dir --target-dir /hdfs/dir/ --query "select * from [DB_SCHEMA_NAME].[table_name] where \$CONDITIONS;" --m 1
... View more
11-04-2019
10:42 PM
hi Abhilash, I am facing same issue while running concurrent sessions at the same point. Did u find a solution to change the temp directory ?
... View more