Moving Large Tables (Data) From Vertica Into MySQL
I use vertica for my analytics and house all my large tables in Vertica. I also have an AWS RDS cluster running MySQL that I would like to export of some of the tables from Vertica into the MySQL instance. What is the fastest and most efficient way of doing this?
Any help is appreciated!
0
Comments
There does not appear to be a cut-and-dried way to export from Vertica to AWS/MySQL. The AWS side would in any case have to support trusted (username-only) or password-based authentication <http://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/AdministratorsGuide/Security/ImplementingSecurity.htm> over which to run EXPORT_TABLES, which will overwrite destination files.
BTW for running Vertica on AWS see <http://my.vertica.com/docs/Ecosystem/Amazon/HP_Vertica_7.1.x_Vertica_AWS.pdf>.