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?
vsql limit
+2
Why do you have the extended formatting enabled? Also, you dont need to specify -P footer=off. Just add t after the A option. You don't need -F '|'. It's the default separator anyways.
+2i did try but issue is not with format but the vsql stopping spooling rows after 1.79 million rows while i have 7 million in the file. Hence asking if there is any limit
What OS are you running on?
+2centos
what's the ouptut of ulimit -a?
Whats's the size of the file you get when you try to dump the table?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
