+2I 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?
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
