Hortonworks Sandbox Forum

HDP Sandbox 2.1 MSSQL Failures

  • #55746
    Ian Henry

    I have been banging my head against the wall on this for an entire day. I am using the HDP vmware sandbox to evaluate the possibility of a hadoop platform. I am totally able to use sqoop to ‘list-tables’ and ‘list-databases’, but every time i attempt an ‘import’ with the following:

    sqoop import --connect "jdbc:sqlserver://xxx.xxx.xxx.xxx:1433;databasename=mydatabase;" --username svc_hadoop --password 'hadoop' --verbose --table my_table

    I am getting the following errors:

    4/06/12 12:45:02 INFO mapreduce.Job:  map 0% reduce 0%
    14/06/12 12:45:12 INFO mapreduce.Job: Task Id : attempt_1402597795499_0009_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:73)
    	at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
    	at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:726)
    	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:340)
    	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:167)
    	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:1557)
    	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162)

    To my knowledge and following the instructions of the link here I have configured the sqljdbc4.jar and sqljdbc.jar drivers/ my MSSQL environment correctly. Any help would be awesome, I can’t seem to find any information on it at all.

to create new topics or reply. | New User Registration

  • Author
  • #55774
    Ian Henry

    I’m still hunting for information on this. Has anybody seen anything like this? I know there is a bug in an older version of sqoop similar to this but here is my version information

    git commit id d3c37763356e55bbf152053f6db24b1bfe582972
    Compiled by jenkins on Wed Apr 16 16:12:40 PDT 2014

    Subversion git@github.com:hortonworks/hadoop.git -r 68ceccf06a4441273e81a5ec856d41fc7e11c792
    Compiled by jenkins on 2014-04-16T21:24Z
    Compiled with protoc 2.5.0
    From source with checksum 9e788148daa5dd7934eb468e57e037b5

    I mean, its a vanilla sandbox install. I would think there would HAVE to be some people that had see this issue crop up.

You must be to reply to this topic. | Create Account

Support from the Experts

A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.

Enterprise Support »

Become HDP Certified

Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world

Training »

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.