is there way store results pig directly table on redshift?
yes, won't - 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 prepare csv , import it.
