Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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!

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB