1 Reply Latest reply on Jan 23, 2020 7:55 PM by Nirmala Sundarappa-Oracle

    Unable to Connect R studio to hive using JDBC Driver

    4166174

      I have recently switched from windows to unix system and when I try to run my code it gives me an error.

       

      Sys.setenv(JAVA_HOME = "/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.221-2.6.18.1.el7.x86_64/")

       

      #set option for Kerberos support. If not set, only login with usercredentials will work

      Sys.setenv(JAVA_TOOL_OPTIONS="-Djavax.security.auth.useSubjectCredsOnly=false")

       

      library("DBI")

      library("rJava")

      library("RJDBC")

       

      cp=c("/opt/hadoop/java/hadoop-auth-2.7.3.2.6.5.0-292.jar"

           ,"/opt/hadoop/java/hadoop-common-2.7.3.2.6.5.0-292.jar"

           ,"/opt/hadoop/java/hive-jdbc-1.2.1000.2.6.5.0-292-standalone.jar"

      )

      .jinit(classpath=cp)

      drv <- JDBC("org.apache.hive.jdbc.HiveDriver",

                  cp,

                 identifier.quote="`")

      conn <-dbConnect(drv,"jdbc:hive2://url")

       

      The error is -

       

      an 08, 2020 4:09:24 PM org.apache.hive.jdbc.Utils parseURL

      INFO: Supplied authorities: url

      Jan 08, 2020 4:09:24 PM org.apache.hive.jdbc.Utils parseURL

      INFO: Resolved authority: url

      Jan 08, 2020 4:09:24 PM org.apache.hive.jdbc.HiveConnection openTransport

      INFO: Will try to open client transport with JDBC Uri: url

      Jan 08, 2020 4:09:24 PM org.apache.hive.jdbc.Utils parseURL

      INFO: Supplied authorities:url

      Jan 08, 2020 4:09:24 PM org.apache.hive.jdbc.Utils parseURL

      INFO: Resolved authority:url

      Jan 08, 2020 4:09:24 PM org.apache.hive.jdbc.HiveConnection openTransport

      INFO: Will try to open client transport with JDBC Uri:url

      Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1],  :

        java.lang.IllegalArgumentException: java.lang.ClassCastException: java.util.Vector cannot be cast to java.util.Hashtable

       

      I cannot share the url but I believe it's right as it works in windows.

       

      I really appreciate your help.