Can vertica-jdbc support "copy" keyword to load data from csv files?
My vertical version is "Vertica Analytic Database v7.2.3-0". My requirement is to load csv files into table by JDBC method. I tried to use "vsql' to load data. It was working.
But use jdbc to execute same sql statement. It raised exception "java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4368) ERROR: Permission denied for storage location".
So I want to know if "vertical-jdbc" doesn't support "copy" keyword?
The following was example code:
Connection con = DriverManager.getConnection(m_VerticaDBURL, m_VerticaDBUserName, m_VerticaDBPassword);
Statement st = con.createStatement();
st.execute(strSql)
0
Comments
Can u share the output of the final string of 'strSql'