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?

preguntada hace 10 meses244 visualizaciones
1 Respuesta
1

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

AWS
respondido hace 10 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas