Why can't I set compression_level with athena CREATE TABLE AS?

0

According to the docs https://docs.aws.amazon.com/athena/latest/ug/compression-support-zstd-levels.html Athena v3 should allow me to set compression level when using ZSTD, but Athena throws a syntax error:

CREATE TABLE some_db."amazingstuff"
    WITH (
        write_compression = 'ZSTD',
        format = 'PARQUET',
        compression_level = '10',
        table_type = 'ICEBERG',
        is_external = false,
        location = 's3://foo/table'
    ) AS
SELECT "id" FROM "schema"."table";

In the AWS console I get:

Unsupported property compression_level.

I'm on Athena v3 because feature changes since v2 like SELECT CONCAT('athena_v3_requires_two_args'); fails. I also can't do ALTER TABLE or any some such. Why is that?

已提問 10 個月前檢視次數 243 次
1 個回答
1

Does it work if you specify the compression level as an integer instead of a string ? compression_level = 10

AWS
已回答 10 個月前

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

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

回答問題指南