I`m working with Vertica. I try to export data from SELECT query into csv. I try to make it with sql query:
SELECT * FROM table_name INTO OUTFILE '/tmp/fileName.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
[Vertica][VJDBC](4856) ERROR: Syntax error at or near "INTO"
vsql -c "select * from table_name;" > /tmp/export_data.txt.
You're using a syntax that's not valid for Vertica. Please read the documentation.
Vertica only supports exports locally.
The client your using needs to have support for a file export. For example, in Excel, you could set up the ODBC connection and import the data.