vertica vsql limit

Moderator: NorbertKrupa

Post Reply
sreediff
Newbie
Newbie
Posts: 18
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
JimKnicely
Site Admin
Site Admin
Posts: 1778
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: vertica vsql limit

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

Hi,

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

Image

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”