0

Is there a way to store the results from Pig directly to a table on Redshift?

Naj11
  • 15
  • 1
  • 4

1 Answers1

0

Yes, but you won't like it probably - it's not efficient.

  1. Download jdbc driver (http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html)

  2. Use PiggyBank DBStorage, mysql example here.

A better way is to prepare csv and then import it.

Community
  • 1
  • 1
rrydziu
  • 56
  • 8