Can you share with us output of the command with —verbose argument? We should print classpath with this argument and I want to see if it happens that there are two JDBC drivers on the classpath - both older and the newer (both sqljdbc4.jar and sqljdbc.jar files) and it just happens that the older is loaded first - I’ve seen this happening before. Alternatively I would look what all JDBC drivers you have on the classpath manually and verify that there is only one MS SQL driver.
> --driver com.microsoft.sqlserver.jdbc.SQLServerDriver Using —driver is almost always wrong thing to do: https://blogs.apache.org/sqoop/entry/connectors_and_drivers_in_the I would strongly recommend to drop the argument. Jarcec > On Feb 3, 2016, at 4:21 AM, Kunal Gaikwad <[email protected]> wrote: > > Hi, > > The “sqljdbc4.jar” is already in the lib folder of the Sqoop folder I tried > running with: > > sudo -u hdfs sqoop import --driver > com.microsoft.sqlserver.jdbc.SQLServerDriver --connect > "jdbc:sqlserver://10.2.40.45;database=RMMBITOOLDB_DailyRev;username=dev;password=dev@123" > --table Product_DailyRevenueDetails_HPOC --split-by ID --hive-import -- > --target-dir "/user/hdfs/K/1" --schema dbo > > and > > > sudo -u hdfs sqoop import --connect > "jdbc:sqlserver://10.2.40.45;database=RMMBITOOLDB_DailyRev;username=dev;password=dev@123" > --table Product_DailyRevenueDetails_HPOC --split-by ID --hive-import -- > --target-dir "/user/hdfs/K/1" --schema dbo > > Still facing the same issue: > > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.8 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) > at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158) > > > > Thanks and regards, > Kunal Anil Gaikwad > Sr. Software Engineer - Big Data > +91 9029648475 > > On Wed, Feb 3, 2016 at 4:54 PM, Vishwakarma, Chhaya > <[email protected]> wrote: > It’s complaining on driver jar you are using for Sqoop-Sqlserver , use this > jar “sqljdbc4.jar” in “lib” folder of Sqoop > > Use this link to download > https://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx > > > > Regards, > > Chhaya > > > > From: Rahul Dhuvad [mailto:[email protected]] > Sent: 03 February 2016 15:47 > To: [email protected] > Subject: Re: Error when importing data from sql server to sqoop > > > > Try giving "--" before "--schema". > > > > Thanks, > > Rahul. > > > > On Wed, Feb 3, 2016 at 2:41 PM, Kunal Gaikwad <[email protected]> wrote: > > i tried removing it (--) but tht given me an error: > > > > sqoop import --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --connect > "jdbc:sqlserver://10.2.40.45;database=RMMBITOOLDB_DailyRev;username=dev;password=dev@123" > --table Product_DailyRevenueDetails_HPOC --split-by ID --hive-import > --target-dir "/user/hdfs/Kunal/2" --schema dbo > > > > Warning: /usr/hdp/2.3.2.0-2950/accumulo does not exist! Accumulo imports will > fail. > > Please set $ACCUMULO_HOME to the root of your Accumulo installation. > > 16/02/03 09:10:15 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.3.2.0-2950 > > 16/02/03 09:10:15 ERROR tool.BaseSqoopTool: Error parsing arguments for > import: > > 16/02/03 09:10:15 ERROR tool.BaseSqoopTool: Unrecognized argument: --schema > > 16/02/03 09:10:15 ERROR tool.BaseSqoopTool: Unrecognized argument: dbo > > > > > > Thanks and regards, > > Kunal Anil Gaikwad > > Sr. Software Engineer - Big Data > +91 9029648475 > > > > On Wed, Feb 3, 2016 at 2:37 PM, Rahul Dhuvad <[email protected]> wrote: > > Can you remove extra "--" just before your "--target-dir" option and see if > that works? > > > > Thanks, > > Rahul. > > > > On Wed, Feb 3, 2016 at 2:35 PM, Kunal Gaikwad <[email protected]> wrote: > > Hi, > > > > I change the hdfs-site.xml for the dfs.permission to false and also deleted > the output file and tried re-running the command. It sometimes say that the > Java version is old or is incompatible. > > > > I have tried two command both of them give me errors: > > > > [root@sandbox conf]# sudo -u hdfs sqoop import --driver > com.microsoft.sqlserver.jdbc.SQLServerDriver --connect > "jdbc:sqlserver://10.2.40.45;database=RMMBITOOLDB_DailyRev;username=dev;password=dev@123" > --table Product_DailyRevenueDetails_HPOC --split-by ID --hive-import -- > --target-dir "/user/hdfs/K/1" --schema dbo > > > > > > Warning: /usr/hdp/2.3.2.0-2950/accumulo does not exist! Accumulo imports will > fail. > > Please set $ACCUMULO_HOME to the root of your Accumulo installation. > > 16/02/03 08:12:51 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.3.2.0-2950 > > 16/02/03 08:12:51 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for > output. You can override > > 16/02/03 08:12:51 INFO tool.BaseSqoopTool: delimiters with > --fields-terminated-by, etc. > > 16/02/03 08:12:51 WARN sqoop.ConnFactory: Parameter --driver is set to an > explicit driver however appropriate connection manager is not being set (via > --connection-manager). Sqoop is going to fall back to > org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which > connection manager should be used next time. > > 16/02/03 08:12:51 INFO manager.SqlManager: Using default fetchSize of 1000 > > 16/02/03 08:12:51 INFO tool.CodeGenTool: Beginning code generation > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > > SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] > > 16/02/03 08:12:53 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/03 08:12:53 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/03 08:12:53 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is > /usr/hdp/2.3.2.0-2950/hadoop-mapreduce > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/PreparedStatement.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/ResultSet.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/SQLException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/DataInput > > .class): major version 52 is newer than 51, the highest major version > supported > by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/DataOutpu > > t.class): major version 52 is newer than 51, the highest major version > supported > by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/IOExcepti > > on.class): major version 52 is newer than 51, the highest major version > supporte > d by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/ByteBuff > > er.class): major version 52 is newer than 51, the highest major version > supporte > d by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/CharBuff > > er.class): major version 52 is newer than 51, the highest major version > supporte > d by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Date.cla > > ss): major version 52 is newer than 51, the highest major version > supported by t > his compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Time.cla > > ss): major version 52 is newer than 51, the highest major version > supported by t > his compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Timestam > > p.class): major version 52 is newer than 51, the highest major version > supported > by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Arrays. > > class): major version 52 is newer than 51, the highest major version > supported b > y this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Iterato > > r.class): major version 52 is newer than 51, the highest major version > supported > by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/List.cl > > ass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Map.cla > > ss): major version 52 is newer than 51, the highest major version > supported by t > his compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/TreeMap > > .class): major version 52 is newer than 51, the highest major version > supported > by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Cloneab > > le.class): major version 52 is newer than 51, the highest major version > supporte > d by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Object. > > class): major version 52 is newer than 51, the highest major version > supported b > y this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Long.cl > > ass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/String. > > class): major version 52 is newer than 51, the highest major version > supported b > y this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Integer > > .class): major version 52 is newer than 51, the highest major version > supported > by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Boolean > > .class): major version 52 is newer than 51, the highest major version > supported > by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/math/BigDeci > > mal.class): major version 52 is newer than 51, the highest major version > support > ed by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Interru > > ptedException.class): major version 52 is newer than 51, the highest major > versi > on supported by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/StringB > > uilder.class): major version 52 is newer than 51, the highest major > version supp > orted by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/CharSeq > > uence.class): major version 52 is newer than 51, the highest major version > suppo > rted by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/CloneNo > > tSupportedException.class): major version 52 is newer than 51, the highest > major > version supported by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Error.c > > lass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Excepti > > on.class): major version 52 is newer than 51, the highest major version > supporte > d by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Throwab > > le.class): major version 52 is newer than 51, the highest major version > supporte > d by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Runtime > > Exception.class): major version 52 is newer than 51, the highest major > version s > upported by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/AutoClo > > seable.class): major version 52 is newer than 51, the highest major > version supp > orted by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Number. > > class): major version 52 is newer than 51, the highest major version > supported b > y this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Date.cl > > ass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Byte.cl > > ass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Charact > > er.class): major version 52 is newer than 51, the highest major version > supporte > d by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Short.c > > lass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Float.c > > lass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Double. > > class): major version 52 is newer than 51, the highest major version > supported b > y this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/Serializa > > ble.class): major version 52 is newer than 51, the highest major version > support > ed by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Compara > > ble.class): major version 52 is newer than 51, the highest major version > support > ed by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Abstrac > > tStringBuilder.class): major version 52 is newer than 51, the highest > major vers > ion supported by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/StringB > > uffer.class): major version 52 is newer than 51, the highest major version > suppo > rted by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/Buffer.c > > lass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Appenda > > ble.class): major version 52 is newer than 51, the highest major version > support > ed by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/ListIte > > rator.class): major version 52 is newer than 51, the highest major version > suppo > rted by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Collect > > ion.class): major version 52 is newer than 51, the highest major version > support > ed by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Iterabl > > e.class): major version 52 is newer than 51, the highest major version > supported > by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/time/LocalDa > > teTime.class): major version 52 is newer than 51, the highest major > version supp > orted by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/math/BigInte > > ger.class): major version 52 is newer than 51, the highest major version > support > ed by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Void.cl > > ass): major version 52 is newer than 51, the highest major version > supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/SortedM > > ap.class): major version 52 is newer than 51, the highest major version > supporte > d by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Compara > > tor.class): major version 52 is newer than 51, the highest major version > support > ed by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Abstrac > > tMap.class): major version 52 is newer than 51, the highest major version > suppor > ted by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/NumberF > > ormatException.class): major version 52 is newer than 51, the highest > major vers > ion supported by this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Illegal > > ArgumentException.class): major version 52 is newer than 51, the highest > major v > ersion supported by this compiler. > > It is recommended that the compiler be upgraded. > > Note: > /tmp/sqoop-hdfs/compile/3e785b24fd99c3effcba50f6eea393c0/Product_DailyReve > > nueDetails_HPOC.java uses or overrides a deprecated API. > > Note: Recompile with -Xlint:deprecation for details. > > 56 warnings > > 16/02/03 08:12:58 INFO orm.CompilationManager: Writing jar file: > /tmp/sqoop-hdfs > > /compile/3e785b24fd99c3effcba50f6eea393c0/Product_DailyRevenueDetails_HPOC.jar > > 16/02/03 08:12:58 INFO mapreduce.ImportJobBase: Beginning import of > Product_Dail > yRevenueDetails_HPOC > > 16/02/03 08:12:59 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* F > ROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/03 08:13:01 INFO impl.TimelineClientImpl: Timeline service address: > http:/ > /sandbox.hortonworks.com:8188/ws/v1/timeline/ > > 16/02/03 08:13:01 INFO client.RMProxy: Connecting to ResourceManager at > sandbox. > hortonworks.com/10.0.2.15:8050 > > 16/02/03 08:13:10 INFO db.DBInputFormat: Using read commited transaction > isolati > on > > 16/02/03 08:13:10 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT > MIN > (ID), MAX(ID) FROM Product_DailyRevenueDetails_HPOC > > 16/02/03 08:13:10 INFO mapreduce.JobSubmitter: number of splits:4 > > 16/02/03 08:13:10 INFO mapreduce.JobSubmitter: Submitting tokens for job: > job_14 > 54412511420_0003 > > 16/02/03 08:13:11 INFO impl.YarnClientImpl: Submitted application > application_14 > 54412511420_0003 > > 16/02/03 08:13:11 INFO mapreduce.Job: The url to track the job: > http://sandbox.h > > ortonworks.com:8088/proxy/application_1454412511420_0003/ > > 16/02/03 08:13:11 INFO mapreduce.Job: Running job: job_1454412511420_0003 > > 16/02/03 08:13:27 INFO mapreduce.Job: Job job_1454412511420_0003 running in > uber mode : false > > 16/02/03 08:13:27 INFO mapreduce.Job: map 0% reduce 0% > > 16/02/03 08:13:55 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000002_0, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:13:55 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000001_0, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:13:55 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000003_0, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:13:55 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000000_0, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:14:08 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000003_1, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:14:09 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000002_1, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > Container killed by the ApplicationMaster. > > Container killed on request. Exit code is 143 > > Container exited with a non-zero exit code 143 > > > > 16/02/03 08:14:09 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000001_1, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:14:10 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000000_1, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:14:19 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000002_2, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:14:20 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000003_2, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:14:21 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000001_2, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:14:23 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0003_m_000000_2, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:14:33 INFO mapreduce.Job: map 100% reduce 0% > > 16/02/03 08:14:35 INFO mapreduce.Job: Job job_1454412511420_0003 failed with > state FAILED due to: Task failed task_1454412511420_0003_m_000002 > > Job failed as tasks failed. failedMaps:1 failedReduces:0 > > > > 16/02/03 08:14:36 INFO mapreduce.Job: Counters: 12 > > Job Counters > > Failed map tasks=13 > > Killed map tasks=3 > > Launched map tasks=16 > > Other local map tasks=16 > > Total time spent by all maps in occupied slots (ms)=213884 > > Total time spent by all reduces in occupied slots (ms)=0 > > Total time spent by all map tasks (ms)=213884 > > Total vcore-seconds taken by all map tasks=213884 > > Total megabyte-seconds taken by all map tasks=53471000 > > Map-Reduce Framework > > CPU time spent (ms)=0 > > Physical memory (bytes) snapshot=0 > > Virtual memory (bytes) snapshot=0 > > 16/02/03 08:14:36 WARN mapreduce.Counters: Group FileSystemCounters is > deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead > > 16/02/03 08:14:36 INFO mapreduce.ImportJobBase: Transferred 0 bytes in > 95.6204 seconds (0 bytes/sec) > > 16/02/03 08:14:36 INFO mapreduce.ImportJobBase: Retrieved 0 records. > > 16/02/03 08:14:36 ERROR tool.ImportTool: Error during import: Import job > failed! > > > > > > > > > > 2. Command > > > > [root@sandbox conf]# sqoop import --driver > com.microsoft.sqlserver.jdbc.SQLServerDriver --connect > "jdbc:sqlserver://10.2.40.45;database=RMMBITOOLDB_DailyRev;username=dev;password=dev@123" > --table Product_DailyRevenueDetails_HPOC --split-by ID --hive-import -- > --target-dir "/user/hdfs/Kunal/2" --schema dbo > > > > Output: > > Warning: /usr/hdp/2.3.2.0-2950/accumulo does not exist! Accumulo imports will > fail. > > Please set $ACCUMULO_HOME to the root of your Accumulo installation. > > 16/02/03 08:15:43 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.3.2.0-2950 > > 16/02/03 08:15:43 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for > output. You can override > > 16/02/03 08:15:43 INFO tool.BaseSqoopTool: delimiters with > --fields-terminated-by, etc. > > 16/02/03 08:15:43 WARN sqoop.ConnFactory: Parameter --driver is set to an > explicit driver however appropriate connection manager is not being set (via > --connection-manager). Sqoop is going to fall back to > org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which > connection manager should be used next time. > > 16/02/03 08:15:43 INFO manager.SqlManager: Using default fetchSize of 1000 > > 16/02/03 08:15:43 INFO tool.CodeGenTool: Beginning code generation > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > > SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] > > 16/02/03 08:15:46 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/03 08:15:46 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/03 08:15:47 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is > /usr/hdp/2.3.2.0-2950/hadoop-mapreduce > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/PreparedStatement.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/ResultSet.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/SQLException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/DataInput.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/DataOutput.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/IOException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/ByteBuffer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/CharBuffer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Date.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Time.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Timestamp.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Arrays.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Iterator.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/List.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Map.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/TreeMap.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Cloneable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Object.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Long.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/String.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Integer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Boolean.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/math/BigDecimal.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/InterruptedException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/StringBuilder.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/CharSequence.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/CloneNotSupportedException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Error.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Exception.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Throwable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/RuntimeException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/AutoCloseable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Number.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Date.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Byte.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Character.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Short.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Float.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Double.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/Serializable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Comparable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/AbstractStringBuilder.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/StringBuffer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/Buffer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Appendable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/ListIterator.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Collection.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Iterable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/time/LocalDateTime.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/math/BigInteger.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Void.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/SortedMap.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Comparator.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/AbstractMap.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/NumberFormatException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/IllegalArgumentException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > Note: > /tmp/sqoop-root/compile/5a166b80fe9b6b534a83e633f0e73a36/Product_DailyRevenueDetails_HPOC.java > uses or overrides a deprecated API. > > Note: Recompile with -Xlint:deprecation for details. > > 56 warnings > > 16/02/03 08:15:53 INFO orm.CompilationManager: Writing jar file: > /tmp/sqoop-root/compile/5a166b80fe9b6b534a83e633f0e73a36/Product_DailyRevenueDetails_HPOC.jar > > 16/02/03 08:15:53 INFO mapreduce.ImportJobBase: Beginning import of > Product_DailyRevenueDetails_HPOC > > 16/02/03 08:15:54 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/03 08:15:59 INFO impl.TimelineClientImpl: Timeline service address: > http://sandbox.hortonworks.com:8188/ws/v1/timeline/ > > 16/02/03 08:15:59 INFO client.RMProxy: Connecting to ResourceManager at > sandbox.hortonworks.com/10.0.2.15:8050 > > 16/02/03 08:16:08 INFO db.DBInputFormat: Using read commited transaction > isolation > > 16/02/03 08:16:08 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT > MIN(ID), MAX(ID) FROM Product_DailyRevenueDetails_HPOC > > 16/02/03 08:16:08 INFO mapreduce.JobSubmitter: number of splits:4 > > 16/02/03 08:16:09 INFO mapreduce.JobSubmitter: Submitting tokens for job: > job_1454412511420_0004 > > 16/02/03 08:16:10 INFO impl.YarnClientImpl: Submitted application > application_1454412511420_0004 > > 16/02/03 08:16:10 INFO mapreduce.Job: The url to track the job: > http://sandbox.hortonworks.com:8088/proxy/application_1454412511420_0004/ > > 16/02/03 08:16:10 INFO mapreduce.Job: Running job: job_1454412511420_0004 > > 16/02/03 08:16:21 INFO mapreduce.Job: Job job_1454412511420_0004 running in > uber mode : false > > 16/02/03 08:16:21 INFO mapreduce.Job: map 0% reduce 0% > > 16/02/03 08:16:37 INFO mapreduce.Job: map 50% reduce 0% > > 16/02/03 08:16:37 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000000_0, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:16:37 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000001_0, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:16:37 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000003_0, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:16:37 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000002_0, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:16:38 INFO mapreduce.Job: map 0% reduce 0% > > 16/02/03 08:16:57 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000001_1, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > Container killed by the ApplicationMaster. > > Container killed on request. Exit code is 143 > > Container exited with a non-zero exit code 143 > > > > 16/02/03 08:16:57 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000002_1, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > Container killed by the ApplicationMaster. > > Container killed on request. Exit code is 143 > > Container exited with a non-zero exit code 143 > > > > 16/02/03 08:16:57 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000003_1, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > Container killed by the ApplicationMaster. > > Container killed on request. Exit code is 143 > > Container exited with a non-zero exit code 143 > > > > 16/02/03 08:16:57 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000000_1, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:17:09 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000001_2, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:17:10 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000002_2, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:17:11 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000003_2, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:17:12 INFO mapreduce.Job: Task Id : > attempt_1454412511420_0004_m_000000_2, Status : FAILED > > Error: java.lang.RuntimeException: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) > > at > org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) > > at > org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) > > at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) > > at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) > > at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164) > > 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.mapred.YarnChild.main(YarnChild.java:158) > > Caused by: java.lang.RuntimeException: > java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) > version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) > > ... 9 more > > Caused by: java.lang.UnsupportedOperationException: Java Runtime Environment > (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class > library, which provides support for JDBC 4.0. > > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.<init>(SQLServerConnection.java:304) > > at > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1011) > > at java.sql.DriverManager.getConnection(DriverManager.java:571) > > at java.sql.DriverManager.getConnection(DriverManager.java:233) > > at > org.apache.sqoop.mapreduce.db.DBConfiguration.getConnection(DBConfiguration.java:300) > > at > org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:213) > > ... 10 more > > > > 16/02/03 08:17:23 INFO mapreduce.Job: map 100% reduce 0% > > 16/02/03 08:17:24 INFO mapreduce.Job: Job job_1454412511420_0004 failed with > state FAILED due to: Task failed task_1454412511420_0004_m_000001 > > Job failed as tasks failed. failedMaps:1 failedReduces:0 > > > > 16/02/03 08:17:25 INFO mapreduce.Job: Counters: 12 > > Job Counters > > Failed map tasks=13 > > Killed map tasks=3 > > Launched map tasks=16 > > Other local map tasks=16 > > Total time spent by all maps in occupied slots (ms)=203779 > > Total time spent by all reduces in occupied slots (ms)=0 > > Total time spent by all map tasks (ms)=203779 > > Total vcore-seconds taken by all map tasks=203779 > > Total megabyte-seconds taken by all map tasks=50944750 > > Map-Reduce Framework > > CPU time spent (ms)=0 > > Physical memory (bytes) snapshot=0 > > Virtual memory (bytes) snapshot=0 > > 16/02/03 08:17:25 WARN mapreduce.Counters: Group FileSystemCounters is > deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead > > 16/02/03 08:17:25 INFO mapreduce.ImportJobBase: Transferred 0 bytes in > 87.2217 seconds (0 bytes/sec) > > 16/02/03 08:17:25 INFO mapreduce.ImportJobBase: Retrieved 0 records. > > 16/02/03 08:17:25 ERROR tool.ImportTool: Error during import: Import job > failed! > > > > > > Thanks and regards, > > Kunal Anil Gaikwad > > Sr. Software Engineer - Big Data > +91 9029648475 > > > > On Wed, Feb 3, 2016 at 1:13 PM, Kunal Gaikwad <[email protected]> wrote: > > I am trying to delete it but it gives me file permission error. > > > > Thanks and regards, > > Kunal Anil Gaikwad > > Sr. Software Engineer - Big Data > +91 9029648475 > > > > On Tue, Feb 2, 2016 at 8:55 PM, Rahul Dhuvad <[email protected]> wrote: > > Hi Kunal, > > > > It seem the target directory already exists for you? > > > > hdfs://sandbox.hortonworks.com:8020/user/hdfs/Product_DailyRevenueDetails_HPOC > already exists > > > > Can you try removing it and rerun Sqoop command to see if that helps? > > > > Thanks, > > Rahul. > > > > On Tue, Feb 2, 2016 at 8:17 PM, Kunal Gaikwad <[email protected]> wrote: > > Hi, > > > > I am getting an error when importing a tablel from sql server to hadoop via > sqoop > > > > Command: > > sudo -u hdfs sqoop import --driver > com.microsoft.sqlserver.jdbc.SQLServerDriver --connect > "jdbc:sqlserver://10.2.40.45;database=RMMBITOOLDB_DailyRev;username=dev;password=dev@123" > --table Product_DailyRevenueDetails_HPOC --split-by ID --hive-import -- > --target-dir "/user/hdfs/K/1" --schema dbo > > > > Error: > > Warning: /usr/hdp/2.3.2.0-2950/accumulo does not exist! Accumulo imports will > fail. > > Please set $ACCUMULO_HOME to the root of your Accumulo installation. > > find: failed to restore initial working directory: Permission denied > > 16/02/02 12:29:19 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.3.2.0-2950 > > 16/02/02 12:29:19 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for > output. You can override > > 16/02/02 12:29:19 INFO tool.BaseSqoopTool: delimiters with > --fields-terminated-by, etc. > > 16/02/02 12:29:19 WARN sqoop.ConnFactory: Parameter --driver is set to an > explicit driver however appropriate connection manager is not being set (via > --connection-manager). Sqoop is going to fall back to > org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which > connection manager should be used next time. > > 16/02/02 12:29:19 INFO manager.SqlManager: Using default fetchSize of 1000 > > 16/02/02 12:29:19 INFO tool.CodeGenTool: Beginning code generation > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > [jar:file:/usr/hdp/2.3.2.0-2950/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > explanation. > > SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] > > 16/02/02 12:29:21 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/02 12:29:21 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/02 12:29:21 INFO orm.CompilationManager: HADOOP_MAPRED_HOME is > /usr/hdp/2.3.2.0-2950/hadoop-mapreduce > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/PreparedStatement.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/ResultSet.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/SQLException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/DataInput.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/DataOutput.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/IOException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/ByteBuffer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/CharBuffer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Date.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Time.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/sql/Timestamp.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Arrays.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Iterator.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/List.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Map.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/TreeMap.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Cloneable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Object.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Long.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/String.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Integer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Boolean.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/math/BigDecimal.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/InterruptedException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/StringBuilder.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/CharSequence.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/CloneNotSupportedException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Error.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Exception.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Throwable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/RuntimeException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/AutoCloseable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Number.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Date.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Byte.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Character.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Short.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Float.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Double.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/io/Serializable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Comparable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/AbstractStringBuilder.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/StringBuffer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/nio/Buffer.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Appendable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/ListIterator.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Collection.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Iterable.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/time/LocalDateTime.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/math/BigInteger.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/Void.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/SortedMap.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/Comparator.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/util/AbstractMap.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/NumberFormatException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > warning: > /usr/jdk64/jdk1.8.0_40/lib/ct.sym(META-INF/sym/rt.jar/java/lang/IllegalArgumentException.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > > It is recommended that the compiler be upgraded. > > Note: > /tmp/sqoop-hdfs/compile/3637923de8c6688f60c6c21e1eb8e568/Product_DailyRevenueDetails_HPOC.java > uses or overrides a deprecated API. > > Note: Recompile with -Xlint:deprecation for details. > > 56 warnings > > 16/02/02 12:29:25 INFO orm.CompilationManager: Writing jar file: > /tmp/sqoop-hdfs/compile/3637923de8c6688f60c6c21e1eb8e568/Product_DailyRevenueDetails_HPOC.jar > > 16/02/02 12:29:25 INFO mapreduce.ImportJobBase: Beginning import of > Product_DailyRevenueDetails_HPOC > > 16/02/02 12:29:26 INFO manager.SqlManager: Executing SQL statement: SELECT > t.* FROM Product_DailyRevenueDetails_HPOC AS t WHERE 1=0 > > 16/02/02 12:29:28 INFO impl.TimelineClientImpl: Timeline service address: > http://sandbox.hortonworks.com:8188/ws/v1/timeline/ > > 16/02/02 12:29:28 INFO client.RMProxy: Connecting to ResourceManager at > sandbox.hortonworks.com/10.0.2.15:8050 > > 16/02/02 12:29:29 ERROR tool.ImportTool: Encountered IOException running > import job: org.apache.hadoop.mapred.FileAlreadyExistsException: Output > directory > hdfs://sandbox.hortonworks.com:8020/user/hdfs/Product_DailyRevenueDetails_HPOC > already exists > > at > org.apache.hadoop.mapreduce.lib.output.FileOutputFormat.checkOutputSpecs(FileOutputFormat.java:146) > > at > org.apache.hadoop.mapreduce.JobSubmitter.checkSpecs(JobSubmitter.java:266) > > at > org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:139) > > at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1290) > > at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1287) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.security.auth.Subject.doAs(Subject.java:422) > > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) > > at org.apache.hadoop.mapreduce.Job.submit(Job.java:1287) > > 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.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:70) > > 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) > > > > I had raised this question on stackoverflow as well link for your reference > is: > > https://stackoverflow.com/questions/35063822/error-while-importing-data-through-sqoop-because-of-no-primary-key-in-the-table > > > > > > Thanks and regards, > > Kunal Anil Gaikwad > > Sr. Software Engineer - Big Data > +91 9029648475 > > > > > > > -- > > Regards, > > Rahul. > > > > > > > > > > > -- > > Regards, > > Rahul. > > > > > > > > > -- > > Regards, > > Rahul. > >
