I have a connection to hive using odbc:
library(DBI) library(odbc) hive_con <- dbConnect(odbc(), dsn = "Hive", Host = "emr-example-running.bi.aws.us.ourco.com", Port = 10000)
When I run this in rstudio the connections pane opens up and I am able to see all of the schemas and tables.
I would like to run a hive command that is not a select statement
MSCK repair table adhoc.mtcars.
DBI::dbSendQuery(hive_con, "MSCK repair table adhoc.mtcars")
That did not work and then when I looked at the documentation for
DBI::dbSendQuery it says
This method is for
Since I'm not trying to write a select query, is there a way to run a hive command using my odbc connection?