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
질문됨 6달 전115회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠