[BUG] Athena: GetQueryExecution reports OutputLocation as a directory prefix instead of the result CSV object key #1752

export AWS_ACCESS_KEY_ID=test AWS_SECRET_ACCESS_KEY=test AWS_DEFAULT_REGION=us-east-1
EP=--endpoint-url=http://localhost:4566

aws $EP s3 mb s3://probe-data
aws $EP s3 mb s3://probe-results
printf '{"eventname":"login","username":"alice"}\n{"eventname":"logout","username":"bob"}\n' > /tmp/events.json
aws $EP s3 cp /tmp/events.json s3://probe-data/events/events.json

aws $EP glue create-database --database-input Name=probedb
aws $EP glue create-table --database-name probedb --table-input '{
  "Name": "events",
  "StorageDescriptor": {
    "Columns": [{"Name":"eventname","Type":"string"},{"Name":"username","Type":"string"}],
    "Location": "s3://probe-data/events/",
    "SerdeInfo": {"SerializationLibrary": "org.openx.data.jsonserde.JsonSerDe"}
  }
}'

QID=$(aws $EP athena start-query-execution \
  --query-string "SELECT eventname, username FROM events WHERE username='alice'" \
  --query-execution-context Database=probedb \
  --result-configuration OutputLocation=s3://probe-results/out/ \
  --query QueryExecutionId --output text)
# first query on a cold container can take minutes while the engine sidecar starts
until [ "$(aws $EP athena get-query-execution --query-execution-id "$QID" \
  --query 'QueryExecution.Status.State' --output text)" = "SUCCEEDED" ]; do sleep 5; done
aws $EP athena get-query-execution --query-execution-id "$QID" \
  --query 'QueryExecution.{State:Status.State,OutputLocation:ResultConfiguration.OutputLocation}'
aws $EP s3 ls s3://probe-results/out/ --recursive
# AWS contract: fetching the key reported in OutputLocation verbatim must succeed — on floci it returns NoSuchKey
OUT=$(aws $EP athena get-query-execution --query-execution-id "$QID" \
  --query 'QueryExecution.ResultConfiguration.OutputLocation' --output text)
aws $EP s3api get-object --bucket probe-results --key "${OUT#s3://probe-results/}" /tmp/result.csv