By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

copy 2TB data from s3 to redshift take more than 2 days is hung

0

the data set is 2 Tera Bytes with 30Billow rows and 80 columns for 20 years history. our redshift cluster is 2 ra3.4xlarge I have successfully loaded 5 years (1/4) of the data set in 6 hours any advice?

Topics
Analytics
Tags
Amazon Redshift
Language
English
Winston
asked 4 months ago128 views
1 Answer
0
Accepted Answer

just talked to AWS Support, they advised to load by chunk by chunk, not all the data in one big load.

Winston
answered 4 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content