sqoop export hive->oracle error(string/varchar column to clob column)

156 Views Asked by At
    [Hive side]
    create table TEST.HIVE_TEST (
    CONTENT string)
    stored as textfile;
    
    [oracle side]
    create table TEST.ORACLE_TEST (
    CONTENT clob);
    
    [sqoop export]
    /usr/bin/sqoop export \
    --connect "connection string"
    --username "ex" password "ex" \
    --table ORACLE_TEST \
    --columns CONTENT \
    --hcatalog-table HIVE_TEST --hcatalog-database TEST \
    --map-column-java CONTENT=String

result of mapreduce is successed but when i see the yarn application log i find ERROR [main] org.apache.sqoop.mapreduce.hcat.SqoopHCatExportHelper : cannot convert hcatalog object of type string to java object type org.apache.sqoop.lib.clobref

and i see null in oracle what is the solution can anyone help?

sqoop version is Sqoop-1.4.7-cdh6.3.4

i hope anyone knows how to export data from string to clob(oracle) using sqoop

0

There are 0 best solutions below