Could you try mapping this to a String? Also, could you please give the command + database schema + example data for us to better understand?
-Abe On Wed, Jun 10, 2015 at 9:51 PM, Kasi Subrahmanyam <[email protected]> wrote: > 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? >
