Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> sqoop2 not work for TEXT columns of oracle


Copy link to this message
-
sqoop2 not work for TEXT columns of oracle
Hi, Expert:
Oracle 11g, varchar2, char type data cannot import
create table tt442222(c1 varCHAR(32), c2 varCHAR(32));
insert into  tt442222 values ('abc', 'abc2');

jdbc:oracle:thin:@//10.103.xx.xx:1521/ENG10GR2.pd.local
jdbc driver name oracle.jdbc.OracleDriver

2014-04-18 15:39:08,117 ERROR mapreduce.MapreduceSubmissionEngine
[org.apache.sqoop.submission.mapreduce.MapreduceSubmissionEngine.submit(MapreduceSubmissionEngine.java:257)]
Error in submitting job
java.lang.ClassCastException: java.lang.Integer cannot be cast to
java.math.BigDecimal
        at
org.apache.sqoop.connector.jdbc.GenericJdbcImportPartitioner.constructTextConditions(GenericJdbcImportPartitioner.java:528)

or
2014-04-18 19:03:38,585 ERROR mapreduce.MapreduceSubmissionEngine
[org.apache.sqoop.submission.mapreduce.MapreduceSubmissionEngine.submit(MapreduceSubmissionEngine.java:257)]
Error in submitting job
org.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0011:The
type is not supported - -15
        at
org.apache.sqoop.connector.jdbc.GenericJdbcImportPartitioner.getPartitions(GenericJdbcImportPartitioner.java:121)
duce.MapreduceSubmissionEngine.submit(MapreduceSubmissionEngine.java:257)]
Error in submitting job
java.lang.ArithmeticException: / by zero
        at java.math.BigDecimal.divideAndRound(BigDecimal.java:1424)
        at java.math.BigDecimal.divide(BigDecimal.java:1398)
Oracle 11g, varchar2, char type data cannot import (2)
See my post above

Error
 a table with two integer columns worked
a mix of nchars and number(38)s not works
or
2014-04-18 19:03:38,585 ERROR mapreduce.MapreduceSubmissionEngine
[org.apache.sqoop.submission.mapreduce.MapreduceSubmissionEngine.submit(MapreduceSubmissionEngine.java:257)]
Error in submitting job
org.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0011:The
type is not supported - -15
        at
org.apache.sqoop.connector.jdbc.GenericJdbcImportPartitioner.getPartitions(GenericJdbcImportPartitioner.java:121)

or

duce.MapreduceSubmissionEngine.submit(MapreduceSubmissionEngine.java:257)]
Error in submitting job
java.lang.ArithmeticException: / by zero
        at java.math.BigDecimal.divideAndRound(BigDecimal.java:1424)
        at
Thanks a lot again!