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!
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>.
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
