I'm writing a script to export data from our Vertica cluster. The command I'm using is:
vsql MY_DB_NAME -At -F$'\t' -o /data/vertica_archive/MY_DATA_2015_07_01.tsv -c "select * from DATA_TABLE where ts_date ='2015-07-01';"
Sporadically resulting with:
server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost
All of our queries are simple "select * from TABLE where ts_date=DATE", but some of the queries result-set will generate a 10GB files.
Example row count:
MY_DB=> select count(*) from DATA_TABLE where ts_date ='2015-07-01'; count ---------- 18213295 (1 row)
Is there any exit code documentation or can any one suggest how to debug?