Athena table location with equal signs in S3 key

0

I'm trying to create a new Athena/Iceberg table in my existing S3 directory structure. The location contains equal signs, e.g. country=all/data. These equal signs are escaped by Athena, which results in a table at the location country%3Dall/data.

Example query:

CREATE TABLE default.testtable (
    id bigint,
    value float) 
LOCATION 's3://my-bucket/country=all/data/mytable/'
TBLPROPERTIES (
  'table_type'='ICEBERG'
)

results in a table at s3://my-bucket/country%3Dall/data/mytable/.

Escaping the location (country\=all) in the query does not work either, as this just adds another escaped character in the path: country%5C%3Dall/.

Question: How can I create a table under a key containing equal signs?

mcsoini
asked 6 months ago112 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions