sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Luke Samaha <lwsam...@gmail.com>
Subject Error Importing Oracle BLOB
Date Mon, 26 Oct 2015 13:05:39 GMT
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.

Mime
View raw message