Moving Large Tables (Data) From Vertica Into MySQL

Ryan_De_Vera

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!

 

 

stalemate

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.

stalemate

BTW for running Vertica on AWS see <http://my.vertica.com/docs/Ecosystem/Amazon/HP_Vertica_7.1.x_Vertica_AWS.pdf>.