COPY vs. LCOPY
Moderator: NorbertKrupa
COPY vs. LCOPY
What is the difference between the COPY and LCOPY commands? Is there a reason why I would use one over the other?
Thank you!
Joshua
Joshua
Re: COPY vs. LCOPY
Hi,
COPY Bulk loads data from one or more files or pipes on a cluster host into a Vertica database. Meaning the files must already be on one of the host servers in the cluster.
LCOPY Loads a data file from a client system into the database. Meaning the file is located locally on the machine of the user. It can only be used via the ODBC interface and is used to actually take the file from your machine to the cluster.
Thus, the use of the commands depends on where the file(s) is located and/or your willingness/access to put the file directly on one of the Vertica cluster servers.
Thanks,
Craig
COPY Bulk loads data from one or more files or pipes on a cluster host into a Vertica database. Meaning the files must already be on one of the host servers in the cluster.
LCOPY Loads a data file from a client system into the database. Meaning the file is located locally on the machine of the user. It can only be used via the ODBC interface and is used to actually take the file from your machine to the cluster.
Thus, the use of the commands depends on where the file(s) is located and/or your willingness/access to put the file directly on one of the Vertica cluster servers.
Thanks,
Craig
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: COPY vs. LCOPY
From the documentation:
The LCOPY function has been removed from the version 5.1 driver. You should instead use the LOCAL option of the COPY SQL statement to copy data from the client system to the server. See Streaming Data From the Client Using COPY LOCAL.
Checkout vertica.tips for more Vertica resources.