Error while loading the data into Impala table using Implyr

General
, , ,
1

Hi Evrryone,

I am creating impala connection from R stduio using odbc drivers and implyr, after that I tried to create the table in impala and load the write the data to the table.Its not working.Can some one please help me on this what could be the wrong.
library(odbc)
library(implyr)
df = read.csv('se_control.csv',header=T,sep=',')
dbExecute(con, "create table stg.test (track STRING, id INT, outlier_flag INT, testcontrol STRING) stored as parquet location '/data/stg/test")
dbExecute(con, "INVALIDATE METADATA stg.test")
dbWriteTable(con, "stg.test", df)

nanodbc/nanodbc.cpp:1587: HY000: [RStudio][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : AnalysisException: Invalid table/view name: stg.test

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.