Details
-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.1.0
-
Fix Version/s: None
-
Component/s: export
-
Labels:None
-
Environment:Fedora 13 64-bit client.
ojdbc6.jar (thin) 11.2 Oracle JDBC driver
Oracle 11.2.0.1 64-bit Server
Description
(1) Create a table in Oracle via:
create table clob (col_clob clob) tablespace users;
insert into clob values ('sldfjsldkfjlksdjflksdfjl');
commit;
(2) Import the data into HDFS using Sqoop:
sqoop import --connect... --table clob -m 1 --inline-lob-limit 0
(3) Create a target table in Oracle via:
create table clob2 tablespace users as (select col_clob from clob where 0=1);
(4) Export the data from HDFS into table clob2 in Oracle:
sqoop export --connect... --table clob2 --export-dir /user/gmar/clob
which results in the error:
10/10/15 10:00:19 INFO mapred.JobClient: map 0% reduce 0%
10/10/15 10:00:33 INFO mapred.JobClient: Task Id : attempt_201010111417_0031_m_000000_0, Status : FAILED
java.io.IOException: Could not buffer record
at com.cloudera.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:202)
at com.cloudera.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:45)
at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:498)
at org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80)
at com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:80)
at com.cloudera.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:38)
at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
at com.cloudera.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:187)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:621)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:305)
at org.apache.hadoop.mapred.Child.main(Child.java:170)
Caused by: java.lang.CloneNotSupportedException: com.cloudera.sqoop.lib.ClobRef
at java.lang.Object.clone(Native Method)
at com.cloudera.sqoop.lib.LobRef.clone(LobRef.java:110)
at clob2.clone(clob2.java:145)
at com.cloudera.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:197)
... 10 more