You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@sqoop.apache.org by Luke Samaha <lw...@gmail.com> on 2015/10/26 14:05:39 UTC

Error Importing Oracle BLOB

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.