Is there a way to store the results from Pig directly to a table on Redshift?
Asked
Active
Viewed 110 times
1 Answers
0
Yes, but you won't like it probably - it's not efficient.
Download jdbc driver (http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html)
Use PiggyBank DBStorage, mysql example here.
A better way is to prepare csv and then import it.