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
.
I tried
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
SELECT
queries only
Since I'm not trying to write a select query, is there a way to run a hive command using my odbc connection?