I am trying to create a table using the CREATE TABLE statement, in hue it works perfectly but when I use the dbexecute function in r, I get an error. How could it be solved.       library(DBI) library(odbc) con_Hive <- dbConnect(odbc::odbc(), "Hive_produccion", database = "cld_ml_bi_eng", encoding = "latin1") con_Hive dbExecute(conn = con_Hive, statement = "CREATE EXTERNAL TABLE iris(sepal_length double, sepal_width double, petal_length double, petal_width double, species varchar(10)) LOCATION '/sandbox/CLD_ML_BI_ENG/iris'") Error: nanodbc/nanodbc.cpp:1655: 42000: [Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [RDIAZ] does not have [CREATE] privilege on [default/iris] <SQL> 'CREATE EXTERNAL TABLE iris(sepal_length double, sepal_width double, petal_length double, petal_width double, species varchar(10)) LOCATION '/sandbox/CLD_ML_BI_ENG/iris'       ... View more

I am using Rstudio and I need to save some tables in my sandbox, however I cannot specify the location, because by default we send the tables to the path: hdfs: //haprod/warehouse/tablespace/managed/hive/cld_ml_bi_eng.db/iris How can I specify the location when writing the table is in the LOCATION '/sandbox/CLD_ML_BI_ENG/iris'   library(DBI) library(odbc) con_Hive <- dbConnect(odbc::odbc(), "Hive_produccion", database = "cld_ml_bi_eng", encoding = "latin1") colnames(iris) <- gsub(pattern = "\\.", replacement = "_", x = colnames(iris)) dbWriteTable(conn = con_Hive, name = Id(schema = "cld_ml_bi_eng", table = "iris"), value = iris) LOCATION '/sandbox/CLD_ML_BI_ENG/iris'   ... View more