Home Forums Hortonworks Sandbox HDP Sandbox 2.1 MSSQL Failures

This topic contains 1 reply, has 1 voice, and was last updated by  Ian Henry 2 months, 2 weeks ago.

  • Creator
    Topic
  • #55746

    Ian Henry
    Participant

    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.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #55774

    Ian Henry
    Participant

    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

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

    Hadoop 2.4.0.2.1.1.0-385
    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.

    Collapse
Viewing 1 replies (of 1 total)