C:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169>sqoop import --connect jdbc:oracle:thin:@//161.186.157.143:1527/huiprd --username hud_reader --password hud_reader_n1le --table PWRLINE_COPY.DATAAGGRUN -m 1 --verbose Warning: HBASE_HOME and HBASE_VERSION not set. Warning: HCATALOG_HOME does not exist HCatalog imports will fail. Please set HCATALOG_HOME to the root of your HCatalog installation. Warning: ACCUMULO_HOME not set. Warning: HBASE_HOME does not exist HBase imports will fail. Please set HBASE_HOME to the root of your HBase installation. Warning: ACCUMULO_HOME does not exist Accumulo imports will fail. Please set ACCUMULO_HOME to the root of your Accumulo installation. 16/04/25 13:17:57 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.0.0-169 16/04/25 13:17:57 DEBUG tool.BaseSqoopTool: Enabled debug logging. 16/04/25 13:17:57 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 16/04/25 13:17:57 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory 16/04/25 13:17:57 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory 16/04/25 13:17:57 DEBUG sqoop.ConnFactory: Trying ManagerFactory: org.apache.sqoop.manager.oracle.OraOopManagerFactory 16/04/25 13:17:57 DEBUG oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop can be called by Sqoop! 16/04/25 13:17:57 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled. 16/04/25 13:17:57 DEBUG sqoop.ConnFactory: Trying ManagerFactory: com.cloudera.sqoop.manager.DefaultManagerFactory 16/04/25 13:17:57 DEBUG manager.DefaultManagerFactory: Trying with scheme: jdbc:oracle:thin:@ 16/04/25 13:17:57 DEBUG manager.OracleManager$ConnCache: Instantiated new connection cache. 16/04/25 13:17:57 INFO manager.SqlManager: Using default fetchSize of 1000 16/04/25 13:17:57 DEBUG sqoop.ConnFactory: Instantiated ConnManager org.apache.sqoop.manager.OracleManager@7c5cc270 16/04/25 13:17:57 INFO tool.CodeGenTool: Beginning code generation 16/04/25 13:17:57 DEBUG manager.OracleManager: Using column names query: SELECT t.* FROM PWRLINE_COPY.DATAAGGRUN t WHERE 1=0 16/04/25 13:17:57 DEBUG manager.SqlManager: Execute getColumnInfoRawQuery : SELECT t.* FROM PWRLINE_COPY.DATAAGGRUN t WHERE 1=0 16/04/25 13:17:57 DEBUG manager.OracleManager: Creating a new connection for jdbc:oracle:thin:@//161.186.157.143:1527/huiprd, using username: hud_reader 16/04/25 13:17:58 DEBUG manager.OracleManager: No connection paramenters specified. Using regular API for making connection. 16/04/25 13:17:58 INFO manager.OracleManager: Time zone has been set to GMT 16/04/25 13:17:58 DEBUG manager.SqlManager: Using fetchSize for next query: 1000 16/04/25 13:17:58 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM PWRLINE_COPY.DATAAGGRUN t WHERE 1=0 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column DATAAGGRUNID of type [2, 19, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column OPERATINGDATE of type [93, 0, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column SETTLEMENTTYPE of type [12, 64, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column RUNNUMBER of type [2, 38, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column UIDMARKET of type [2, 19, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column PROFILESTARTDATE of type [93, 0, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column PROFILESTOPDATE of type [93, 0, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column CUTOFFDATE of type [93, 0, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column IDRPARALLEL of type [2, 38, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column TRUNCATESTAGING of type [1, 1, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column PUBLISHED of type [1, 1, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column PROXYDAYTYPE of type [12, 64, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column LSUSER of type [12, 64, 0] 16/04/25 13:17:58 DEBUG manager.SqlManager: Found column LSTIME of type [93, 0, 0] 16/04/25 13:17:58 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@//161.186.157.143:1527/huiprd/hud_reader 16/04/25 13:17:58 DEBUG orm.ClassWriter: selected columns: 16/04/25 13:17:58 DEBUG orm.ClassWriter: DATAAGGRUNID 16/04/25 13:17:58 DEBUG orm.ClassWriter: OPERATINGDATE 16/04/25 13:17:58 DEBUG orm.ClassWriter: SETTLEMENTTYPE 16/04/25 13:17:58 DEBUG orm.ClassWriter: RUNNUMBER 16/04/25 13:17:58 DEBUG orm.ClassWriter: UIDMARKET 16/04/25 13:17:58 DEBUG orm.ClassWriter: PROFILESTARTDATE 16/04/25 13:17:58 DEBUG orm.ClassWriter: PROFILESTOPDATE 16/04/25 13:17:58 DEBUG orm.ClassWriter: CUTOFFDATE 16/04/25 13:17:58 DEBUG orm.ClassWriter: IDRPARALLEL 16/04/25 13:17:58 DEBUG orm.ClassWriter: TRUNCATESTAGING 16/04/25 13:17:58 DEBUG orm.ClassWriter: PUBLISHED 16/04/25 13:17:58 DEBUG orm.ClassWriter: PROXYDAYTYPE 16/04/25 13:17:58 DEBUG orm.ClassWriter: LSUSER 16/04/25 13:17:58 DEBUG orm.ClassWriter: LSTIME 16/04/25 13:17:59 DEBUG orm.ClassWriter: Writing source file: \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\PWRLINE_COPY_DATAAGGRUN.java 16/04/25 13:17:59 DEBUG orm.ClassWriter: Table name: PWRLINE_COPY.DATAAGGRUN 16/04/25 13:17:59 DEBUG orm.ClassWriter: Columns: DATAAGGRUNID:2, OPERATINGDATE:93, SETTLEMENTTYPE:12, RUNNUMBER:2, UIDMARKET:2, PROFILESTARTDATE:93, PROFILESTOPDATE:93, CUTOFFDATE:93, IDRPARALLEL:2, TRUNCAT 16/04/25 13:17:59 DEBUG orm.ClassWriter: sourceFilename is PWRLINE_COPY_DATAAGGRUN.java 16/04/25 13:17:59 DEBUG orm.CompilationManager: Found existing \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\ 16/04/25 13:17:59 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169 16/04/25 13:17:59 DEBUG orm.CompilationManager: Returning jar file path c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\hadoop-common-2.7.1.2.4.0.0-169-tests.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0 \hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\hadoop-mapreduce-client-core-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\sources\hadoop-mapreduce-client-co 16/04/25 13:17:59 DEBUG orm.CompilationManager: Current sqoop classpath = c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\etc\hadoop;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\activation-1.1.jar;c adoop\common\lib\asm-3.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\avro-1.7.4.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\aws-java-sdk-1.7.4.jar;c:\hadoop\hdp\ -codec-1.4.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\commons-collections-3.2.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\commons-compress-1.4.1.jar;c:\hadoop s-lang-2.6.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\commons-logging-1.1.3.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\commons-math3-3.1.1.jar;c:\hadoop\hdp\ha c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\guava-11.0.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\hadoop-annotations-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2. lib\httpclient-4.2.5.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\httpcore-4.2.5.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\jackson-annotations-2.2.3.jar;c:\hado ckson-mapper-asl-1.9.13.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\jackson-xc-1.9.13.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\java-xmlbuilder-0.4.jar;c:\hado \hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\jets3t-0.9.0.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\jettison-1.1.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hado \common\lib\junit-4.11.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\log4j-1.2.17.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\microsoft-windowsazure-storage-sdk-0. let-api-2.5.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\slf4j-api-1.7.10.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\slf4j-log4j12-1.7.10.jar;c:\hadoop\hdp\hadoo adoop-2.7.1.2.4.0.0-169\share\hadoop\common\hadoop-aws-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\hadoop-azure-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-1 0.0-169\share\hadoop\hdfs\lib\commons-cli-1.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\commons-codec-1.4.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\commons-daemo 3.1.0-incubating.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\jackson-core-asl-1.9.13.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\jackson-mapper-asl-1.9.13.jar;c:\had p\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\leveldbjni-all-1.8.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\log4j-1.2.17.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\h \lib\servlet-api-2.5.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\xercesImpl-2.9.1.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\xml-apis-1.3.04.jar;c:\hadoop\hdp\hadoo c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\aopalliance-1.0.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\asm-3.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\shar 4.0.0-169\share\hadoop\mapreduce\lib\hadoop-annotations-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\hamcrest-core-1.3.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\sh oop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\jersey-server-1.9.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\junit-4.11.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share 7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\snappy-java-1.0.4.1.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\xz-1.0.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\h 1.2.4.0.0-169\share\hadoop\mapreduce\hadoop-mapreduce-client-hs-plugins-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\hadoop-mapreduce-client-jobclient-2.7.1.2.4.0.0-169 -169.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\sqoop-test-1.4.6.2.4.0.0-169.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\ant-contrib-1.0b3.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\ant-eclipse-1.0-jvm1. .2.4.0.0-169\lib\commons-jexl-2.1.1.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\commons-logging-1.1.1.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\hsqldb-1.8.0.10.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169 lib\kite-data-core-1.0.0.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\kite-data-hive-1.0.0.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\kite-data-mapreduce-1.0.0.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\l op\hdp\sqoop-1.4.6.2.4.0.0-169\lib\parquet-common-1.4.1.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\parquet-encoding-1.4.1.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\parquet-format-2.0.0.jar;c:\hadoop\h 0.0-169\lib\snappy-java-1.0.5.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\xz-1.0.jar;c:\hadoop\hdp\zookeeper-3.4.6.2.4.0.0-169\conf;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\conf\*;;c:\hadoop\hdp\tez-0.7.0.2.4 -0.7.0.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\tez-runtime-internals-0.7.0.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\tez-runtime-library-0.7.0.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2. p\tez-0.7.0.2.4.0.0-169\lib\commons-cli-1.2.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\commons-codec-1.4.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\commons-collections-3.2.2.jar;c:\hadoop\hdp\tez-0.7.0.2.4 s-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\hadoop-azure-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\hadoop-mapreduce-client-common-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\t 4.0.0-169\lib\jettison-1.3.4.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\jetty-6.1.26.hwx.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\jetty-util-6.1.26.hwx.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\jsr305- 16/04/25 13:17:59 DEBUG orm.CompilationManager: Adding source file: \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\PWRLINE_COPY_DATAAGGRUN.java 16/04/25 13:17:59 DEBUG orm.CompilationManager: Invoking javac with args: 16/04/25 13:17:59 DEBUG orm.CompilationManager: -sourcepath 16/04/25 13:17:59 DEBUG orm.CompilationManager: \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\ 16/04/25 13:17:59 DEBUG orm.CompilationManager: -d 16/04/25 13:17:59 DEBUG orm.CompilationManager: \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\ 16/04/25 13:17:59 DEBUG orm.CompilationManager: -classpath 16/04/25 13:17:59 DEBUG orm.CompilationManager: c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\etc\hadoop;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\activation-1.1.jar;c:\hadoop\hdp\hadoop-2.7. .jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\avro-1.7.4.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\aws-java-sdk-1.7.4.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169 \hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\commons-collections-3.2.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\commons-compress-1.4.1.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0. \hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\commons-logging-1.1.3.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\commons-math3-3.1.1.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\s .1.2.4.0.0-169\share\hadoop\common\lib\guava-11.0.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\hadoop-annotations-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\ha ;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\httpcore-4.2.5.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\jackson-annotations-2.2.3.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4. jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\jackson-xc-1.9.13.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\java-xmlbuilder-0.4.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4. .2.4.0.0-169\share\hadoop\common\lib\jets3t-0.9.0.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\jettison-1.1.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\jetty-6.1. ar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\log4j-1.2.17.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\microsoft-windowsazure-storage-sdk-0.6.0.jar;c:\hadoop\hdp\ha p\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\slf4j-api-1.7.10.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\lib\slf4j-log4j12-1.7.10.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\shar share\hadoop\common\hadoop-aws-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\hadoop-azure-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\h s\lib\commons-cli-1.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\commons-codec-1.4.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\commons-daemon-1.0.13.jar;c:\hadoop\h hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\jackson-core-asl-1.9.13.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\jackson-mapper-asl-1.9.13.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4 .0-169\share\hadoop\hdfs\lib\leveldbjni-all-1.8.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\log4j-1.2.17.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\netty-3.6.2.Fina ;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\xercesImpl-2.9.1.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\hdfs\lib\xml-apis-1.3.04.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\shar .1.2.4.0.0-169\share\hadoop\mapreduce\lib\aopalliance-1.0.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\asm-3.2.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\a apreduce\lib\hadoop-annotations-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\hamcrest-core-1.3.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib .0.0-169\share\hadoop\mapreduce\lib\jersey-server-1.9.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\junit-4.11.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\le doop\mapreduce\lib\snappy-java-1.0.4.1.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\lib\xz-1.0.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\hadoop-mapreduce-client-a op\mapreduce\hadoop-mapreduce-client-hs-plugins-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\mapreduce\hadoop-mapreduce-client-jobclient-2.7.1.2.4.0.0-169-tests.jar;c:\hadoop\hdp qoop-1.4.6.2.4.0.0-169\sqoop-test-1.4.6.2.4.0.0-169.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\ant-contrib-1.0b3.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\ant-eclipse-1.0-jvm1.2.jar;c:\hadoop\hdp\sqoo -jexl-2.1.1.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\commons-logging-1.1.1.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\hsqldb-1.8.0.10.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\jackson-annotations .jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\kite-data-hive-1.0.0.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\kite-data-mapreduce-1.0.0.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\kite-hadoop-compatibi .0-169\lib\parquet-common-1.4.1.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\parquet-encoding-1.4.1.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\parquet-format-2.0.0.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-1 1.0.5.jar;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\lib\xz-1.0.jar;c:\hadoop\hdp\zookeeper-3.4.6.2.4.0.0-169\conf;c:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\conf\*;;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\conf\;c:\hadoop :\hadoop\hdp\tez-0.7.0.2.4.0.0-169\tez-runtime-internals-0.7.0.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\tez-runtime-library-0.7.0.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\tez-tests-0.7. lib\commons-cli-1.2.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\commons-codec-1.4.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\commons-collections-3.2.2.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\commons-col c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\hadoop-azure-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\hadoop-mapreduce-client-common-2.7.1.2.4.0.0-169.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib .3.4.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\jetty-6.1.26.hwx.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\jetty-util-6.1.26.hwx.jar;c:\hadoop\hdp\tez-0.7.0.2.4.0.0-169\lib\jsr305-2.0.3.jar;c:\hadoop\hdp\ p\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\sources\hadoop-common-2.7.1.2.4.0.0-169-sources.jar;c:\hadoop\hdp\hadoop-2.7.1.2.4.0.0-169\share\hadoop\common\sources\hadoop-common-2.7.1.2.4.0.0-169-test- 69\share\hadoop\mapreduce\sources\hadoop-mapreduce-client-core-2.7.1.2.4.0.0-169-test-sources.jar;/C:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/sqoop-1.4.6.2.4.0.0-169.jar Note: \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\PWRLINE_COPY_DATAAGGRUN.java uses or overrides a deprecated API. Note: Recompile with -Xlint:deprecation for details. 16/04/25 13:18:02 DEBUG orm.CompilationManager: Could not rename \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\PWRLINE_COPY_DATAAGGRUN.java to C:\hadoop\hdp\sqoop-1.4.6.2.4.0.0-169\.\PWRLINE_COPY 16/04/25 13:18:02 INFO orm.CompilationManager: Writing jar file: \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\PWRLINE_COPY.DATAAGGRUN.jar 16/04/25 13:18:02 DEBUG orm.CompilationManager: Scanning for .class files in directory: \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4 16/04/25 13:18:02 DEBUG orm.CompilationManager: Got classfile: \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\PWRLINE_COPY_DATAAGGRUN.class -> PWRLINE_COPY_DATAAGGRUN.class 16/04/25 13:18:02 DEBUG orm.CompilationManager: Finished writing jar file \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\PWRLINE_COPY.DATAAGGRUN.jar 16/04/25 13:18:02 DEBUG manager.OracleManager$ConnCache: Got cached connection for jdbc:oracle:thin:@//161.186.157.143:1527/huiprd/hud_reader 16/04/25 13:18:02 INFO manager.OracleManager: Time zone has been set to GMT 16/04/25 13:18:02 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@//161.186.157.143:1527/huiprd/hud_reader 16/04/25 13:18:02 DEBUG manager.OracleManager$ConnCache: Got cached connection for jdbc:oracle:thin:@//161.186.157.143:1527/huiprd/hud_reader 16/04/25 13:18:02 INFO manager.OracleManager: Time zone has been set to GMT 16/04/25 13:18:02 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@//161.186.157.143:1527/huiprd/hud_reader 16/04/25 13:18:02 INFO mapreduce.ImportJobBase: Beginning import of PWRLINE_COPY.DATAAGGRUN 16/04/25 13:18:02 DEBUG util.ClassLoaderStack: Checking for existing class: PWRLINE_COPY_DATAAGGRUN 16/04/25 13:18:02 DEBUG util.ClassLoaderStack: Attempting to load jar through URL: jar:file:/C:/tmp/sqoop-sahus/compile/7d30d2bd017c3b4ad98a1fbba3dc1dc4/PWRLINE_COPY.DATAAGGRUN.jar!/ 16/04/25 13:18:02 DEBUG util.ClassLoaderStack: Previous classloader is sun.misc.Launcher$AppClassLoader@18247418 16/04/25 13:18:02 DEBUG util.ClassLoaderStack: Testing class in jar: PWRLINE_COPY_DATAAGGRUN 16/04/25 13:18:02 DEBUG util.ClassLoaderStack: Loaded jar into current JVM: jar:file:/C:/tmp/sqoop-sahus/compile/7d30d2bd017c3b4ad98a1fbba3dc1dc4/PWRLINE_COPY.DATAAGGRUN.jar!/ 16/04/25 13:18:02 DEBUG util.ClassLoaderStack: Added classloader for jar \tmp\sqoop-sahus\compile\7d30d2bd017c3b4ad98a1fbba3dc1dc4\PWRLINE_COPY.DATAAGGRUN.jar: java.net.FactoryURLClassLoader@71a32422 16/04/25 13:18:03 INFO Configuration.deprecation: mapred.jar is deprecated. Instead, use mapreduce.job.jar 16/04/25 13:18:03 DEBUG db.DBConfiguration: Securing password into job credentials store 16/04/25 13:18:03 DEBUG manager.OracleManager$ConnCache: Got cached connection for jdbc:oracle:thin:@//161.186.157.143:1527/huiprd/hud_reader 16/04/25 13:18:03 INFO manager.OracleManager: Time zone has been set to GMT 16/04/25 13:18:03 DEBUG manager.OracleManager$ConnCache: Caching released connection for jdbc:oracle:thin:@//161.186.157.143:1527/huiprd/hud_reader 16/04/25 13:18:03 DEBUG mapreduce.DataDrivenImportJob: Using table class: PWRLINE_COPY_DATAAGGRUN 16/04/25 13:18:03 DEBUG mapreduce.DataDrivenImportJob: Using InputFormat: class com.cloudera.sqoop.mapreduce.db.OracleDataDrivenDBInputFormat 16/04/25 13:18:04 INFO Configuration.deprecation: mapred.map.tasks is deprecated. Instead, use mapreduce.job.maps 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/C:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/sqoop-1.4.6.2.4.0.0-169.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/C:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/ojdbc6.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/C:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/sqoop-1.4.6.2.4.0.0-169.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/C:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/sqoop-1.4.6.2.4.0.0-169.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/ant-contrib-1.0b3.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/ant-eclipse-1.0-jvm1.2.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/avro-1.7.5.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/avro-ipc-1.7.5-tests.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/avro-mapred-1.7.5.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/commons-codec-1.4.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/commons-compress-1.4.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/commons-io-1.4.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/commons-jexl-2.1.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/commons-logging-1.1.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/hsqldb-1.8.0.10.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/jackson-annotations-2.3.0.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/jackson-core-2.3.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/jackson-core-asl-1.9.13.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/jackson-databind-2.3.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/jackson-mapper-asl-1.9.13.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/jetty-util-6.1.26.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/kite-data-core-1.0.0.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/kite-data-hive-1.0.0.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/kite-data-mapreduce-1.0.0.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/kite-hadoop-compatibility-1.0.0.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/netty-3.4.0.Final.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/ojdbc6.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/opencsv-2.3.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/paranamer-2.3.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/parquet-avro-1.4.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/parquet-column-1.4.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/parquet-common-1.4.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/parquet-encoding-1.4.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/parquet-format-2.0.0.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/parquet-generator-1.4.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/parquet-hadoop-1.4.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/parquet-jackson-1.4.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/servlet-api-2.5-20081211.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/simplefan.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/slf4j-api-1.6.1.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/snappy-java-1.0.5.jar 16/04/25 13:18:04 DEBUG mapreduce.JobBase: Adding to job classpath: file:/c:/hadoop/hdp/sqoop-1.4.6.2.4.0.0-169/lib/xz-1.0.jar 16/04/25 13:18:04 DEBUG util.ClassLoaderStack: Restoring classloader: sun.misc.Launcher$AppClassLoader@18247418 Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/hadoop/yarn/exceptions/YarnException at org.apache.hadoop.mapred.YarnClientProtocolProvider.create(YarnClientProtocolProvider.java:34) at org.apache.hadoop.mapreduce.Cluster.initialize(Cluster.java:95) at org.apache.hadoop.mapreduce.Cluster.(Cluster.java:82) at org.apache.hadoop.mapreduce.Cluster.(Cluster.java:75) at org.apache.hadoop.mapreduce.Job$9.run(Job.java:1260) at org.apache.hadoop.mapreduce.Job$9.run(Job.java:1256) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at org.apache.hadoop.mapreduce.Job.connect(Job.java:1255) at org.apache.hadoop.mapreduce.Job.submit(Job.java:1284) at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:1308) at org.apache.sqoop.mapreduce.ImportJobBase.doSubmitJob(ImportJobBase.java:196) at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:169) at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:266) at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:673) at org.apache.sqoop.manager.OracleManager.importTable(OracleManager.java:444) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:497) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605) at org.apache.sqoop.Sqoop.run(Sqoop.java:148) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235) at org.apache.sqoop.Sqoop.main(Sqoop.java:244) Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.yarn.exceptions.YarnException at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) ... 25 more