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?