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?

gefragt vor 10 Monaten243 Aufrufe
1 Antwort
1

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

AWS
beantwortet vor 10 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen