Page 1 of 1

vertica vsql limit

Posted: Mon Aug 08, 2016 5:43 pm
by sreediff
vertica sql spool limit
I am trying to create dump of table using vsql -vsql -U -w -F "|" -P footer=off -AXnqc "select * from USER_SLCT" > USER_SLCT.csv
The table has 7 million rows but the output of the above shows only 1.79 million. Is there any limit in vsql?

Re: vertica vsql limit

Posted: Sat Aug 13, 2016 2:24 am
by JimKnicely

I am not aware or any limit. Make sure you are selecting from the table you think you are. I don't see a schema name :)

Also, maybe try the -o option of vsql instead of redirection in Linux? The -o option lets you specify an output file.

Something as simple as:

Code: Select all

vsql -Atc "select * from USER_SLCT" -o USER_SLCT.csv