...

• For Hive, you can publish Avro or Parquet results from HDFS or S3 to Hive.

• For Redshift, you can publish CSV, JSON, or Avro results from S3 to Redshift.

  Info
  NOTE: To publish to Redshift, results must be written first to S3.

  Info
  NOTE: By default, data is published to Redshift using the public schema. To publish using a different schema, Even if you are publishing to the default schema, you mustpreface the table value with the name of the schema to use: MySchema.MyTable.

...