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?

Winston
已提問 4 個月前檢視次數 135 次
1 個回答
0
已接受的答案

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

Winston
已回答 4 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南