0

According to the Athena Iceberg documentation, the map type is supported.

Why do neither of these statements work?

CREATE TABLE iceberg_test1 (id string, themap map)
  LOCATION 's3://mybucket/test/iceberg1'
  TBLPROPERTIES ( 'table_type' = 'ICEBERG' );

Error:

Iceberg query cannot be parsed

Second try:

CREATE TABLE iceberg_test1 (id string, themap map<varchar,varchar>)
  LOCATION 's3://mybucket/test/iceberg1'
  TBLPROPERTIES ( 'table_type' = 'ICEBERG' );

Same error:

Iceberg query cannot be parsed

Alex R
  • 11,364
  • 15
  • 100
  • 180

1 Answers1

1

Neither map (without specifying the key/value types) nor varchar are valid Iceberg types. See the Iceberg documentation for valid types.

CREATE TABLE iceberg_test1 (id string, themap map<string, string>)
  LOCATION 's3://mybucket/test/iceberg1'
  TBLPROPERTIES ( 'table_type' = 'ICEBERG' );

will work as long as you have permissions to access the S3 location.

rcauvin
  • 91
  • 5