Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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)

Comments

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.