I'm able to sqoop everything from our Oracle tables except the BLOBs. -- example of successful command: sqoop import --connect jdbc:oracle:thin:@//host:1521/svc --username me --password secret --query 'select parcel_uid from table where $CONDITIONS' --split-by 'parcel_uid' --target-dir /data/out/tmp --verbose
15/10/26 08:50:00 INFO mapreduce.Job: Job job_local519954001_0001 completed successfully -- example failed command (select a blob column called "data"): sqoop import --connect jdbc:oracle:thin:@//host:1521/svc --username me --password secret --query 'select data from table where $CONDITIONS' --split-by 'parcel_uid' --target-dir /data/out/tmp --verbose 15/10/26 08:52:45 INFO manager.SqlManager: Executing SQL statement: select data from table where (1 = 0) 15/10/26 08:52:45 ERROR tool.ImportTool: Imported Failed: For input string: "4294967295" Please advise.
