R Shiny: Unable to retrieve JDBC result set for vertica DB

Question

Getting below error while using vertica copy table from local.

Please suggest

Error:Unable to retrieve JDBC result set for COPY Monetisation_Base_table FROM LOCAL 'E://testCSV.csv' delimiter ',' ([Vertica]JDBC A ResultSet was expected but not generated from query "COPY Monetisation_Base_table FROM LOCAL 'E://testCSV.csv' delimiter ','". Query not executed. )

Code Used:

library(RJDBC)
vDriver <- JDBC(driverClass="com.vertica.jdbc.Driver", classPath="full\path\to\driver\vertica_jdbc_VERSION.jar")
vertica <- dbConnect(vDriver, "jdbc:vertica://30.0.9.163:5433/db", "sk14930IU", "Snapdeal_40")
myframe = dbGetQuery(vertica, "COPY Monetisation_Base_table FROM LOCAL 'E://testCSV.csv' delimiter ','"")

IMHO, you should add the rjdbc tag to your question. – user31264 May 27 '16 at 13:25 — user31264, May 27 '16 at 13:25

score 3 · Answer 1 · answered May 31 '16 at 11:59

3

dbSendUpdate should do the work in this case .

answered May 31 '16 at 11:59

elirevach

404
2
7

It works fine on Linux. However on WIndows it says " Cant open file for reading. No such file or directory". I tried to specify path multiple ways. Do you know any workaroud ? – Vadym B. Aug 11 '16 at 10:17

R Shiny: Unable to retrieve JDBC result set for vertica DB

1 Answers1