Can we use CTAS in icebeg tables? - if yes, how?

0

I was trying to create table from select query - in iceberg. I was not able to. Can we use CTAS in icebeg tables? - if yes, how?

  • Short answer is YES. To tell how more detail is required. Are you using Athena ? Trino ? Spark SQL ?

Bharat
已提問 9 個月前檢視次數 353 次
1 個回答
1
已接受的答案

Hello,


Yes, we can use CTAS with iceberg table. You can refer to below AWS documentation and create table syntax.

Sample query:

CREATE TABLE ctas_iceberg_parquet WITH (table_type = 'ICEBERG', format = 'PARQUET', location = 's3://my_athena_results/ctas_iceberg_parquet/', is_external = false, partitioning = ARRAY['month(dt)'], vacuum_min_snapshots_to_keep = 10, vacuum_max_snapshot_age_ms = 259200 ) AS SELECT key1, name1, dt FROM table1;

profile pictureAWS
支援工程師
已回答 9 個月前

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

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

回答問題指南