sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasi Subrahmanyam <kasisubbu...@gmail.com>
Subject Exporting large string
Date Wed, 10 Jun 2015 18:51:06 GMT
Hi Team,

I have a column in hive table whose value is of datatype string and has
characters more than 4000.
I want to export this hive table to Oracle DB and the possible column
datatype i can give in DB is varchar2(4000) or CLOB. Clearly using
varchar2(4000) is throwing an error out and so i could only use CLoB on the
DB side.


When i use CLOB on DB the sqoop export is throwing an error out.


Caused by: java.io.IOException: Could not buffer record
        at
org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:218)
        at
org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:46)
        at
org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:591)
        at
org.apache.hadoop.mapreduce.task.TaskInputOutputContextImpl.write(TaskInputOutputContextImpl.java:85)
        at
org.apache.hadoop.mapreduce.lib.map.WrappedMapper$Context.write(WrappedMapper.java:106)
        at
org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:84)
        ... 10 more
Caused by: java.lang.CloneNotSupportedException:
com.cloudera.sqoop.lib.ClobRef
        at java.lang.Object.clone(Native Method)
        at org.apache.sqoop.lib.LobRef.clone(LobRef.java:109)







 So am i missing out something before doing the export , like to set any
other property on the sqoop end?

Mime
View raw message