Hi,
Getting error while i run the below script. Attached screenshot. Can anybody help me on this
> library("DBI")
> library("RJDBC")
> drv <- JDBC("org.apache.hive.jdbc.HiveDriver", identifier.quote="`")
Error in .jfindClass(as.character(driverClass)[1]) : class not found
> .jcall("java/lang/System","S","setProperty","javax.security.auth.useSubjectCredsOnly","false")
NULL
> conn <- dbConnect(drv,"jdbc:hive2://usaepapp009r2.acloud.experian.corp:10000/default;principal=hive/[usaepapp009r2.acloud.experian.corp@BDL.GDC.LOCAL](mailto:usaepapp009r2.acloud.experian.corp@BDL.GDC.LOCAL);saslQop=auth-conf")
Error in dbConnect(drv, "jdbc:hive2://usaepapp009r2.acloud.experian.corp:10000/default;principal=hive/[usaepapp009r2.acloud.experian.corp@BDL.GDC.LOCAL](mailto:usaepapp009r2.acloud.experian.corp@BDL.GDC.LOCAL);saslQop=auth-conf") :
object 'drv' not found
> dbGetQuery(conn, "show databases")
Error in dbGetQuery(conn, "show databases") : object 'conn' not found
Thanks