使用 AWS re:Post 即表示您同意 AWS re:Post 使用條款
AWS re:Postre:Post

Supported S3 Storage Classes for Redshift Spectrum

0

I'm trying to read files from S3 using redshift spectrum. After creating the external table, I can see that nothing is being read. This post says that spectrum or Athena can't read S3 files from Glacier Deep Archive even if they've been restored.

I want to confirm if this is accurate and if so, what options I have in order to be able to query directly using Spectrum.

主題
儲存空間分析
標籤
Amazon Simple Storage ServiceAmazon S3 GlacierAmazon Redshift
語言
English
timosky
已提問 10 個月前檢視次數 630 次
2 個答案
0

Once data is in Glacier, then Redshift Spectrum cannot access it.

You must restore the data back to S3.

AWS
vtjean
已回答 10 個月前
  • timosky
    10 個月前

    I have already restored and I can confirm that the restoration is complete. However, when I create an external table with the restored data as the location, the table returns 0 rows.

    I've already tested my DDL with a subset of the data (in the standard storage class) and I can confirm everything works fine. I'm not too sure what else might be causing the external table to return 0 rows.

0

You can use the Amazon S3 Glacier Instant Retrieval storage class, which is queryable by Amazon Athena but not Amazon Redshift. To use the objects under S3 Glacier flexible retrieval or S3 Glacier Deep Archive storage classes, you need to copy the restored objects back into Amazon S3 to actually change their storage class.

profile pictureAWS
MilindOke
已回答 10 個月前

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

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

回答問題指南

相關內容