Export Vertica query result to csv file

sql csv export vertica
Opperix picture Opperix · Oct 21, 2014 · Viewed 20k times · Source

I`m working with Vertica. I try to export data from SELECT query into csv. I tried making it with sql query:

SELECT * FROM table_name INTO OUTFILE '/tmp/fileName.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

I got an error:

[Vertica][VJDBC](4856) ERROR: Syntax error at or near "INTO"

Is there a way to export a query result to a csv file? I prefer not to use vsql, but if there no other way, I will use it. I tried the following:

vsql -c "select * from table_name;" > /tmp/export_data.txt

Answer

Marcus Couto picture Marcus Couto · Nov 5, 2015

Here is how you do it:

vsql -U dbadmin -F ',' -A -P footer=off -o dumpfile.txt -c "select ... from ... where ...;"

Reference: Exporting Data Using vsql

Related questions

MySQL dump into CSV text files with column names at the top?

Possible Duplicate: How to export / dump a MySql table into a text file including the field names (aka headers or column names) I use this SQL snippet to dump a table into CSV text files: SELECT * FROM brand INTO OUTFILE "…

Read More
Exporting data from SQL Server Express to CSV (need quoting and escaping)

I've spent 2 days trying to export a 75,000 row table containing a large text field of user input data from a SQL server installation. This data contains every plain ascii character, tabs, and newlines. I need to export CSV where every …

Read More
How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary?

Read More