sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Elmahrek <...@cloudera.com>
Subject Re: Exporting large string
Date Thu, 11 Jun 2015 19:04:26 GMT
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 <kasisubbu440@gmail.com>
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?
>

Mime
View raw message