set 'iceberg.unique-table-location=true', even though it is set.

[dominikhei]

Hello, I get the error:

Cannot create a table on a non-empty location: s3a://sample-lakehouse/raw/user_data/, set 'iceberg.unique-table-location=true' in your Iceberg catalog properties to use unique table locations for every table.

This is the sql statement I am trying to execute:

CREATE SCHEMA iceberg.raw with (LOCATION = 's3a://sample-lakehouse/raw/');
CREATE TABLE iceberg.raw.user_data (
    registration_dttm   timestamp(6),
        id              int,
        first_name      varchar,
        last_name       varchar,
        email           varchar,
        gender          varchar,
        ip_address      varchar,
        cc              varchar,
        country         varchar,
        birthdate       varchar,
        salary          double,
        title           varchar,
        comments        varchar
)
COMMENT 'Table with sample user data'
WITH (
    format = 'PARQUET',
    sorted_by = ARRAY['id'],
    location = 's3a://sample-lakehouse/raw/user_data/'
); 

My iceberg.properties file looks like this:

connector.name=iceberg
iceberg.unique-table-location=true
hive.metastore.uri=thrift://hive-metastore:9083
hive.s3.path-style-access=true
hive.s3.endpoint=http://minio:9000/
hive.s3.aws-access-key=test
hive.s3.aws-secret-key=test12334567

Is there anything I have done wrong?

[ebyhr]

Please remove location table property from CREATE TABLE statement if you want to use unique locations.