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
preguntada hace 6 meses115 visualizaciones
No hay respuestas

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