Can I copy bulk load without a file?

David_P_1David_P_1 Registered User
edited April 2017 in Vertica Forum

I would like to write a Python script to select data from a MySQL database, and copy bulk load that data into a Vertica database.

Is there a way to do this without a file? It would be faster to have no file, and just copy from memory? Perhaps using the STDIN parameter?

https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/COPY/COPY.htm

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file