vertica vsql limit

[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?

[JimKnicely]

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