CODEWITHSUNDEEP
hiveamazon-redshift
user2715877
user2715877

Reputation: 543

AWS Redshift COPY from S3

I am trying to copy Hive created SEQUENCE files from S3 to Redshift. What do I need to add as an "OPTION" to have Redshift properly recognize the filetype? Thanks!

Upvotes: 1

Views: 388

Answers (1)

ciphor
ciphor

Reputation: 8288

It depends on the format of the output file from Hive. For compression type, redshift supports GZIP or LZOP, and for file type, redshift supports flat file, csv or json, you may also use DELIMITER to specify the column delimiter. And you may also need to use DATEFORMAT/TIMEFORMAT to specify the date/time format used in the output file.

Not sure if this answers your question.

Upvotes: 1

Related Questions