This is an R client to interact with the Apache Hive data warehouse, including wrapper functions around the Hive JDBC Uber Jar.
install.packages("hiveuberjar")
Or you can easily install the most recent development version of the R package as well:
devtools::install_github('nfultz/hiveuberjar')
This provides a simplified DBI driver for Hive:
require(DBI)
con <- dbConnect(hiveuberjar::HiveUber(), url="jdbc://host:port/schema")
dbListTables(con)
dbGetQuery(con, "Select *count(*) from nfultz.iris limit 10")
Installing and loading the JDBC driver package is handled automatically. Authentication via kerberos is also supported.
Most database functionality is actually provided by RJDBC, but if you have Hive-specific features in mind, please open a ticket on the feature request, or even better, submit a pull request :)
Please open an issue here on github.