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();


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file