How do I resolve the partition projection error "INVALID_TABLE_PROPERTY" when I query a table in Athena?

1 minute read
0

I used partition projection with an Amazon Athena table, and the query failed with the error "INVALID_TABLE_PROPERTY".

Short description

This error occurs when the storage.location.template property is incorrect in the Athena table definition that's used with partition projection.

Resolution

Make sure that the table definition that's specified in the storage.location.template property is correct. Also, make sure that the range values are separated by a comma instead of a hyphen.

The following Amazon Simple Storage Service (Amazon S3) bucket is the default Athena partition path template:

s3://bucket/table-root/partition-col-1=partition-col-1-val/partition-col-2=partition-col-2-val/

To use a custom path Amazon S3 template, see Specifying custom S3 storage locations.

The following example table uses partition columns a, b, and c. These example storage.location.template values are correct:

s3://bucket/table_root/a=${a}/${b}/some_static_subdirectory/${c}/
s3://bucket/table_root/c=${c}/${b}/some_static_subdirectory/${a}/${b}/${c}/${c}/

These example.storage.location.template values aren't correct because there isn't a placeholder for column a:

s3://bucket/table_root/c=${c}/${b}/some_static_subdirectory/
s3://bucket/table_root/some_static_subdirectory/{b}/${c}

For more information, see Setting up partition projection and Partitioning issues.

Related information

Partition projection with Amazon Athena

Troubleshooting in Athena

AWS OFFICIAL
AWS OFFICIALUpdated a month ago