We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

Can I copy bulk load without a file? — Vertica Forum

Can I copy bulk load without a file?

David_P_1

David_P_1

April 2017 edited April 2017 in General Discussion

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

0

Comments

swalkaus Vertica Employee Employee

April 2017

The following package loads data from an odbc source. It is a little dated and I haven't used it so I can say for certain that it works. Nonetheless, it might be useful to you.
https://github.com/vertica/Vertica-Extension-Packages/tree/master/odbc_loader_package

0

Leave a Comment