Hi,
I am using vertica windows vsql from windows machine for storing query output in gzip format. When I run the command through vsql command line, the result is not being exported to the given location, the generated file size remains 0 kb and the query is running infinitely in the database , As I know the query generally takes less time to run.
But when I execute the command without gzip compression , the query runs successfully.
I have used below command
C:\Test\vsql.exe -U -w -h -F "|" -At -c ";" | "C:\Test\gzip.exe" -f > "C:\Temp\Results.gz"
Can anyone suggest how to make the export faster.
Thanks
Ajit