vertica vsql limit

Forum to discuss topics specific to the Vertica Community Edition

Moderator: NorbertKrupa

Post Reply
Posts: 17
Joined: Mon Mar 28, 2016 2:51 pm

vertica vsql limit

Post by sreediff » Mon Aug 08, 2016 5:43 pm

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?

User avatar
Site Admin
Site Admin
Posts: 1738
Joined: Sat Jan 21, 2012 4:58 am

Re: vertica vsql limit

Post by JimKnicely » Sat Aug 13, 2016 2:24 am


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
Jim Knicely


Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Community Edition”

Who is online

Users browsing this forum: No registered users and 0 guests