hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ajit Kumar Shreevastava <Ajit.Shreevast...@hcl.com>
Subject Error while exporting table data from hive to Oracle through Sqoop
Date Tue, 05 Mar 2013 13:54:13 GMT
Hi All,

I am facing following issue while exporting table from hive to Oracle. Importing table from
Oracle to Hive and HDFS is working fine. Please let me know where I lag. I am pasting my screen
output here.


[hadoop@NHCLT-PC44-2 sqoop-oper]$ sqoop export --connect jdbc:oracle:thin:@10.99.42.11:1521/clouddb
--username HDFSUSER  --table BTTN_BKP --export-dir  /home/hadoop/user/hive/warehouse/bttn
 -P --verbose  -m 1  --input-fields-terminated-by '\001'
Warning: /usr/lib/hbase does not exist! HBase imports will fail.
Please set $HBASE_HOME to the root of your HBase installation.
13/03/05 19:20:11 DEBUG tool.BaseSqoopTool: Enabled debug logging.
Enter password:
13/03/05 19:20:16 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory
13/03/05 19:20:16 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory
13/03/05 19:20:16 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:oracle:thin:@10.99.42.11
13/03/05 19:20:16 DEBUG manager.OracleManager$ConnCache: Instantiated new connection cache.
13/03/05 19:20:16 INFO manager.SqlManager: Using default fetchSize of 1000
13/03/05 19:20:16 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.OracleManager@2abe0e27
13/03/05 19:20:16 INFO tool.CodeGenTool: Beginning code generation
13/03/05 19:20:16 DEBUG manager.OracleManager: Using column names query: SELECT t.* FROM BTTN_BKP
t WHERE 1=0
13/03/05 19:20:16 DEBUG manager.OracleManager: Creating a new connection for jdbc:oracle:thin:@10.99.42.11:1521/clouddb,
using username: HDFSUSER
13/03/05 19:20:16 DEBUG manager.OracleManager: No connection paramenters specified. Using
regular API for making connection.
13/03/05 19:20:16 INFO manager.OracleManager: Time zone has been set to GMT
13/03/05 19:20:16 DEBUG manager.SqlManager: Using fetchSize for next query: 1000
13/03/05 19:20:16 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM BTTN_BKP
t WHERE 1=0
13/03/05 19:20:16 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@10.99.42.11:1521/clouddb/HDFSUSER
13/03/05 19:20:16 DEBUG orm.ClassWriter: selected columns:
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BTTN_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   DATA_INST_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   SCR_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BTTN_NU
13/03/05 19:20:16 DEBUG orm.ClassWriter:   CAT
13/03/05 19:20:16 DEBUG orm.ClassWriter:   WDTH
13/03/05 19:20:16 DEBUG orm.ClassWriter:   HGHT
13/03/05 19:20:16 DEBUG orm.ClassWriter:   KEY_SCAN
13/03/05 19:20:16 DEBUG orm.ClassWriter:   KEY_SHFT
13/03/05 19:20:16 DEBUG orm.ClassWriter:   FRGND_CPTN_COLR
13/03/05 19:20:16 DEBUG orm.ClassWriter:   FRGND_CPTN_COLR_PRSD
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BKGD_CPTN_COLR
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BKGD_CPTN_COLR_PRSD
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BLM_FL
13/03/05 19:20:16 DEBUG orm.ClassWriter:   LCLZ_FL
13/03/05 19:20:16 DEBUG orm.ClassWriter:   MENU_ITEM_NU
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BTTN_ASGN_LVL_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   ON_ATVT
13/03/05 19:20:16 DEBUG orm.ClassWriter:   ON_CLIK
13/03/05 19:20:16 DEBUG orm.ClassWriter:   ENBL_FL
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BLM_SET_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BTTN_ASGN_LVL_NAME
13/03/05 19:20:16 DEBUG orm.ClassWriter:   MKT_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   CRTE_TS
13/03/05 19:20:16 DEBUG orm.ClassWriter:   CRTE_USER_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   UPDT_TS
13/03/05 19:20:16 DEBUG orm.ClassWriter:   UPDT_USER_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   DEL_TS
13/03/05 19:20:16 DEBUG orm.ClassWriter:   DEL_USER_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   DLTD_FL
13/03/05 19:20:16 DEBUG orm.ClassWriter:   MENU_ITEM_NA
13/03/05 19:20:16 DEBUG orm.ClassWriter:   PRD_CD
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BLM_SET_NA
13/03/05 19:20:16 DEBUG orm.ClassWriter:   SOUND_FILE_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   IS_DYNMC_BTTN
13/03/05 19:20:16 DEBUG orm.ClassWriter:   FRGND_CPTN_COLR_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   FRGND_CPTN_COLR_PRSD_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BKGD_CPTN_COLR_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter:   BKGD_CPTN_COLR_PRSD_ID
13/03/05 19:20:16 DEBUG orm.ClassWriter: Writing source file: /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/BTTN_BKP.java
13/03/05 19:20:16 DEBUG orm.ClassWriter: Table name: BTTN_BKP
13/03/05 19:20:16 DEBUG orm.ClassWriter: Columns: BTTN_ID:2, DATA_INST_ID:2, SCR_ID:2, BTTN_NU:2,
CAT:2, WDTH:2, HGHT:2, KEY_SCAN:2, KEY_SHFT:2, FRGND_CPTN_COLR:12, FRGND_CPTN_COLR_PRSD:12,
BKGD_CPTN_COLR:12, BKGD_CPTN_COLR_PRSD:12, BLM_FL:2, LCLZ_FL:2, MENU_ITEM_NU:2, BTTN_ASGN_LVL_ID:2,
ON_ATVT:2, ON_CLIK:2, ENBL_FL:2, BLM_SET_ID:2, BTTN_ASGN_LVL_NAME:12, MKT_ID:2, CRTE_TS:93,
CRTE_USER_ID:12, UPDT_TS:93, UPDT_USER_ID:12, DEL_TS:93, DEL_USER_ID:12, DLTD_FL:2, MENU_ITEM_NA:12,
PRD_CD:2, BLM_SET_NA:12, SOUND_FILE_ID:2, IS_DYNMC_BTTN:2, FRGND_CPTN_COLR_ID:2, FRGND_CPTN_COLR_PRSD_ID:2,
BKGD_CPTN_COLR_ID:2, BKGD_CPTN_COLR_PRSD_ID:2,
13/03/05 19:20:16 DEBUG orm.ClassWriter: sourceFilename is BTTN_BKP.java
13/03/05 19:20:16 DEBUG orm.CompilationManager: Found existing /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/
13/03/05 19:20:16 INFO orm.CompilationManager: HADOOP_HOME is /home/hadoop/hadoop-1.0.3/libexec/..
13/03/05 19:20:16 DEBUG orm.CompilationManager: Adding source file: /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/BTTN_BKP.java
13/03/05 19:20:16 DEBUG orm.CompilationManager: Invoking javac with args:
13/03/05 19:20:16 DEBUG orm.CompilationManager:   -sourcepath
13/03/05 19:20:16 DEBUG orm.CompilationManager:   /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/
13/03/05 19:20:16 DEBUG orm.CompilationManager:   -d
13/03/05 19:20:16 DEBUG orm.CompilationManager:   /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/
13/03/05 19:20:16 DEBUG orm.CompilationManager:   -classpath
13/03/05 19:20:16 DEBUG orm.CompilationManager:   /home/hadoop/hadoop-1.0.3/libexec/../conf:/usr/java/jdk1.6.0_32/lib/tools.jar:/home/hadoop/hadoop-1.0.3/libexec/..:/home/hadoop/hadoop-1.0.3/libexec/../hadoop-core-1.0.3.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/asm-3.2.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/aspectjrt-1.6.5.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/aspectjtools-1.6.5.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-beanutils-1.7.0.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-beanutils-core-1.8.0.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-cli-1.2.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-codec-1.4.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-collections-3.2.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-configuration-1.6.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-daemon-1.0.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-digester-1.8.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-el-1.0.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-httpclient-3.0.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-io-2.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-lang-2.4.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-logging-1.1.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-logging-api-1.0.4.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-math-2.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/commons-net-1.4.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/core-3.1.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/hadoop-capacity-scheduler-1.0.3.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/hadoop-fairscheduler-1.0.3.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/hadoop-thriftfs-1.0.3.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/hsqldb-1.8.0.10.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jackson-core-asl-1.8.8.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jackson-mapper-asl-1.8.8.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jasper-compiler-5.5.12.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jasper-runtime-5.5.12.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jdeb-0.8.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jersey-core-1.8.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jersey-json-1.8.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jersey-server-1.8.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jets3t-0.6.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jetty-6.1.26.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jetty-util-6.1.26.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jsch-0.1.42.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/junit-4.5.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/kfs-0.2.2.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/log4j-1.2.15.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/mockito-all-1.8.5.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/oro-2.0.8.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/servlet-api-2.5-20081211.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/slf4j-api-1.4.3.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/slf4j-log4j12-1.4.3.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/xmlenc-0.52.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jsp-2.1/jsp-2.1.jar:/home/hadoop/hadoop-1.0.3/libexec/../lib/jsp-2.1/jsp-api-2.1.jar:/home/hadoop/sqoop/conf::/home/hadoop/sqoop/lib/ant-contrib-1.0b3.jar:/home/hadoop/sqoop/lib/ant-eclipse-1.0-jvm1.2.jar:/home/hadoop/sqoop/lib/avro-1.5.3.jar:/home/hadoop/sqoop/lib/avro-ipc-1.5.3.jar:/home/hadoop/sqoop/lib/avro-mapred-1.5.3.jar:/home/hadoop/sqoop/lib/commons-io-1.4.jar:/home/hadoop/sqoop/lib/hsqldb-1.8.0.10.jar:/home/hadoop/sqoop/lib/jackson-core-asl-1.7.3.jar:/home/hadoop/sqoop/lib/jackson-mapper-asl-1.7.3.jar:/home/hadoop/sqoop/lib/jopt-simple-3.2.jar:/home/hadoop/sqoop/lib/ojdbc6.jar:/home/hadoop/sqoop/lib/paranamer-2.3.jar:/home/hadoop/sqoop/lib/snappy-java-1.0.3.2.jar:/home/hadoop/sqoop/sqoop-1.4.2.jar:/home/hadoop/sqoop/sqoop-test-1.4.2.jar::/home/hadoop/hadoop-1.0.3/hadoop-core-1.0.3.jar:/home/hadoop/sqoop/sqoop-1.4.2.jar
Note: /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/BTTN_BKP.java uses or overrides
a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
13/03/05 19:20:18 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/BTTN_BKP.jar
13/03/05 19:20:18 DEBUG orm.CompilationManager: Scanning for .class files in directory: /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e
13/03/05 19:20:18 DEBUG orm.CompilationManager: Got classfile: /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/BTTN_BKP.class
-> BTTN_BKP.class
13/03/05 19:20:18 DEBUG orm.CompilationManager: Finished writing jar file /tmp/sqoop-hadoop/compile/8d22103beede09e961b64d0ff8e61e7e/BTTN_BKP.jar
13/03/05 19:20:18 INFO mapreduce.ExportJobBase: Beginning export of BTTN_BKP
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Using InputFormat: class org.apache.sqoop.mapreduce.ExportInputFormat
13/03/05 19:20:18 DEBUG manager.OracleManager$ConnCache: Got cached connection for jdbc:oracle:thin:@10.99.42.11:1521/clouddb/HDFSUSER
13/03/05 19:20:18 INFO manager.OracleManager: Time zone has been set to GMT
13/03/05 19:20:18 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@10.99.42.11:1521/clouddb/HDFSUSER
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/sqoop-1.4.2.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/ojdbc6.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/sqoop-1.4.2.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/sqoop-1.4.2.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/jackson-mapper-asl-1.7.3.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/hsqldb-1.8.0.10.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/avro-ipc-1.5.3.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/jopt-simple-3.2.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/ojdbc6.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/jackson-core-asl-1.7.3.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/ant-contrib-1.0b3.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/ant-eclipse-1.0-jvm1.2.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/snappy-java-1.0.3.2.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/paranamer-2.3.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/avro-1.5.3.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/commons-io-1.4.jar
13/03/05 19:20:18 DEBUG mapreduce.JobBase: Adding to job classpath: file:/home/hadoop/sqoop/lib/avro-mapred-1.5.3.jar
13/03/05 19:20:19 INFO input.FileInputFormat: Total input paths to process : 4
13/03/05 19:20:19 DEBUG mapreduce.ExportInputFormat: Target numMapTasks=1
13/03/05 19:20:19 DEBUG mapreduce.ExportInputFormat: Total input bytes=184266237
13/03/05 19:20:19 DEBUG mapreduce.ExportInputFormat: maxSplitSize=184266237
13/03/05 19:20:19 INFO input.FileInputFormat: Total input paths to process : 4
13/03/05 19:20:19 DEBUG mapreduce.ExportInputFormat: Generated splits:
13/03/05 19:20:19 DEBUG mapreduce.ExportInputFormat:   Paths:/home/hadoop/user/hive/warehouse/bttn/part-m-00000:0+20908340,/home/hadoop/user/hive/warehouse/bttn/part-m-00001:0+67108864,/home/hadoop/user/hive/warehouse/bttn/part-m-00001:67108864+24822805,/home/hadoop/user/hive/warehouse/bttn/part-m-00002:0+26675150,/home/hadoop/user/hive/warehouse/bttn/part-m-00003:0+44751078
Locations:NHCLT-PC44-2.hclt.corp.hcl.in:;
13/03/05 19:20:19 INFO mapred.JobClient: Running job: job_201303051835_0010
13/03/05 19:20:20 INFO mapred.JobClient:  map 0% reduce 0%
13/03/05 19:20:36 INFO mapred.JobClient:  map 7% reduce 0%
13/03/05 19:20:39 INFO mapred.JobClient:  map 11% reduce 0%
13/03/05 19:20:42 INFO mapred.JobClient:  map 16% reduce 0%
13/03/05 19:20:45 INFO mapred.JobClient:  map 17% reduce 0%
13/03/05 19:20:48 INFO mapred.JobClient:  map 20% reduce 0%
13/03/05 19:20:51 INFO mapred.JobClient:  map 27% reduce 0%
13/03/05 19:20:54 INFO mapred.JobClient:  map 32% reduce 0%
13/03/05 19:20:57 INFO mapred.JobClient:  map 33% reduce 0%
13/03/05 19:21:01 INFO mapred.JobClient:  map 38% reduce 0%
13/03/05 19:21:04 INFO mapred.JobClient:  map 39% reduce 0%
13/03/05 19:21:07 INFO mapred.JobClient:  map 43% reduce 0%
13/03/05 19:21:10 INFO mapred.JobClient:  map 44% reduce 0%
13/03/05 19:21:13 INFO mapred.JobClient:  map 48% reduce 0%
13/03/05 19:21:18 INFO mapred.JobClient: Task Id : attempt_201303051835_0010_m_000000_0, Status
: FAILED
java.util.NoSuchElementException
        at java.util.AbstractList$Itr.next(AbstractList.java:350)
        at BTTN_BKP.__loadFromFields(BTTN_BKP.java:1349)
        at BTTN_BKP.parse(BTTN_BKP.java:1148)
       at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:77)
        at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:36)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
        at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182)
        at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:764)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:370)
        at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1121)
        at org.apache.hadoop.mapred.Child.main(Child.java:249)

13/03/05 19:21:19 INFO mapred.JobClient:  map 0% reduce 0%
13/03/05 19:21:27 INFO mapred.JobClient: Task Id : attempt_201303051835_0010_m_000000_1, Status
: FAILED
java.io.IOException: java.sql.BatchUpdateException: ORA-00001: unique constraint (HDFSUSER.BTTN_BKP_PK)
violated

        at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:220)
        at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:46)
        at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.write(MapTask.java:639)
        at org.apache.hadoop.mapreduce.TaskInputOutputContext.write(TaskInputOutputContext.java:80)
        at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:78)
        at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:36)
        at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:144)
        at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:182)
        at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:764)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:370)
        at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1121)
        at org.apache.hadoop.mapred.Child.main(Child.java:249)
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (HDFSUSER.BTTN_BKP_PK)
violated

        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
        at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
        at org.apache.sqoop.mapreduce.AsyncSqlOutputFormat$AsyncSqlExecThread.run(AsyncSqlOutputFormat.java:228)

13/03/05 19:21:48 WARN mapred.JobClient: Error reading task outputConnection timed out
13/03/05 19:22:09 WARN mapred.JobClient: Error reading task outputConnection timed out
13/03/05 19:22:09 INFO mapred.JobClient: Job complete: job_201303051835_0010
13/03/05 19:22:09 INFO mapred.JobClient: Counters: 8
13/03/05 19:22:09 INFO mapred.JobClient:   Job Counters
13/03/05 19:22:09 INFO mapred.JobClient:     SLOTS_MILLIS_MAPS=77152
13/03/05 19:22:09 INFO mapred.JobClient:     Total time spent by all reduces waiting after
reserving slots (ms)=0
13/03/05 19:22:09 INFO mapred.JobClient:     Total time spent by all maps waiting after reserving
slots (ms)=0
13/03/05 19:22:09 INFO mapred.JobClient:     Rack-local map tasks=3
13/03/05 19:22:09 INFO mapred.JobClient:     Launched map tasks=4
13/03/05 19:22:09 INFO mapred.JobClient:     Data-local map tasks=1
13/03/05 19:22:09 INFO mapred.JobClient:     SLOTS_MILLIS_REDUCES=0
13/03/05 19:22:09 INFO mapred.JobClient:     Failed map tasks=1
13/03/05 19:22:09 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 110.4837 seconds (0
bytes/sec)
13/03/05 19:22:09 INFO mapreduce.ExportJobBase: Exported 0 records.
13/03/05 19:22:09 ERROR tool.ExportTool: Error during export: Export job failed!
[hadoop@NHCLT-PC44-2 sqoop-oper]$

Regards,
Ajit Kumar Shreevastava


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named
recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted,
corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e
mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator
or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may
not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying,
disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized
representative of
HCL is strictly prohibited. If you have received this email in error please delete it and
notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------

Mime
View raw message