[Email protected] ~]$ sqoop import-connect jdbc:oracle:thin:@192.168.8.228:1521:bonc-username Aq-password bonc1234-t Able Orcl_test1-hive-import-
Hive-database test-hive-table orcl_hive_test1-null-string "-null-non-string"-M 1
15/06/11 17:05:58 INFO Sqoop. Sqoop:running Sqoop version:1.4.4-cdh5.0.0
15/06/11 17:05:58 WARN tool. Basesqooptool:setting your password on the command-line is insecure. Consider Using-p instead.
15/06/11 17:05:58 INFO tool. Basesqooptool:using hive-specific delimiters for output. You can override
15/06/11 17:05:58 INFO tool. Basesqooptool:delimiters with--fields-terminated-by, etc.
15/06/11 17:05:58 INFO Manager. sqlmanager:using default Fetchsize of 1000
15/06/11 17:05:58 INFO tool. Codegentool:beginning code Generation
15/06/11 17:05:59 INFO Manager. Oraclemanager:time zone have been set to GMT
15/06/11 17:05:59 INFO Manager. Sqlmanager:executing SQL statement:select t.* from Orcl_test1 t WHERE 1=0
15/06/11 17:05:59 INFO Orm.CompilationManager:HADOOP_MAPRED_HOME is/opt/beh/core/hadoop
Note:/tmp/sqoop-hadoop/compile/7808ec7272d1b4eaa5af7d983f35fcd9/orcl_test1.java uses or overrides a deprecated API.
Note:recompile with-xlint:deprecation for details.
15/06/11 17:06:01 INFO Orm. compilationmanager:writing jar File:/tmp/sqoop-hadoop/compile/7808ec7272d1b4eaa5af7d983f35fcd9/orcl_test1.jar
15/06/11 17:06:01 INFO Manager. Oraclemanager:time zone have been set to GMT
15/06/11 17:06:01 INFO Manager. Oraclemanager:time zone have been set to GMT
15/06/11 17:06:01 INFO MapReduce. Importjobbase:beginning Import of Orcl_test1
15/06/11 17:06:02 INFO Configuration.deprecation:mapred.jar is deprecated. Instead, use Mapreduce.job.jar
15/06/11 17:06:02 INFO Manager. Oraclemanager:time zone have been set to GMT
15/06/11 17:06:03 INFO Configuration.deprecation:mapred.map.tasks is deprecated. Instead, use Mapreduce.job.maps
15/06/11 17:06:03 INFO Client. Rmproxy:connecting to ResourceManager at/0.0.0.0:8032
15/06/11 17:06:04 INFO db. Dbinputformat:using Read commited Transaction isolation
15/06/11 17:06:04 INFO MapReduce. Jobsubmitter:number of Splits:1
15/06/11 17:06:05 INFO MapReduce. Jobsubmitter:submitting Tokens for job:job_1432609090750_0032
15/06/11 17:06:05 INFO Impl. yarnclientimpl:submitted Application application_1432609090750_0032
15/06/11 17:06:05 INFO MapReduce. Job:the URL to track the job:http://mdhadoop:23188/proxy/application_1432609090750_0032/
15/06/11 17:06:05 INFO MapReduce. Job:running job:job_1432609090750_0032
15/06/11 17:06:14 INFO MapReduce. Job:job job_1432609090750_0032 running in Uber Mode:false
15/06/11 17:06:14 INFO MapReduce. Job:map 0% Reduce 0%
15/06/11 17:06:20 INFO MapReduce. Job:task Id:attempt_1432609090750_0032_m_000000_0, status:failed
Error:oracle.jdbc.driver.T4CPreparedStatement.isClosed () Z
15/06/11 17:06:26 INFO MapReduce. Job:task Id:attempt_1432609090750_0032_m_000000_1, status:failed
Error:oracle.jdbc.driver.T4CPreparedStatement.isClosed () Z
15/06/11 17:06:32 INFO MapReduce. Job:task Id:attempt_1432609090750_0032_m_000000_2, status:failed
Error:oracle.jdbc.driver.T4CPreparedStatement.isClosed () Z
15/06/11 17:06:40 INFO MapReduce. Job:map 100% Reduce 0%
15/06/11 17:06:41 INFO MapReduce. Job:job job_1432609090750_0032 failed with state failed due To:task failed task_1432609090750_0032_m_000000
Job failed as tasks failed. Failedmaps:1 failedreduces:0
15/06/11 17:06:41 INFO MapReduce. Job:counters:8
Job Counters
Failed Map tasks=4
Launched Map tasks=4
Other local map tasks=4
Total time spent by all maps in occupied slots (ms) =18943
Total time spent by all reduces in occupied slots (ms) =0
Total time spent by all map tasks (ms) =18943
Total Vcore-seconds taken by all map tasks=18943
Total Megabyte-seconds taken by all map tasks=19397632
15/06/11 17:06:41 WARN MapReduce. Counters:group filesystemcounters is deprecated. Use Org.apache.hadoop.mapreduce.FileSystemCounter instead
15/06/11 17:06:41 INFO MapReduce. importjobbase:transferred 0 bytes in 38.4552 seconds (0 bytes/sec)
15/06/11 17:06:41 WARN MapReduce. Counters:group Org.apache.hadoop.mapred.task$counter is deprecated. Use Org.apache.hadoop.mapreduce.TaskCounter instead
15/06/11 17:06:41 INFO MapReduce. Importjobbase:retrieved 0 Records.
15/06/11 17:06:41 ERROR tool. Importtool:error during Import:import job failed!
[Email protected] ~]$
The JDBC driver is 10g, and the update to 11g solves the
ERROR:oracle.jdbc.driver.T4CPreparedStatement.isClosed () Z (Sqoop data from Oralce to hive) resolved