Hugh file needs to be loaded in Vertica using COPY
We have a Vertica cluster of 3 nodes. And we have to load data into vertica.
Each of the compressed file size is of 3GBs or more.
Can you please let me know is there any efficient way to load into vertica?
Currently we are using COPY with DIRECT.. But still its taking hugh amount of time and some times its failing also...
Thanks in advance..