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?