AWS Athena against S3 with Sub-folders

Question

Hi 
I've created a crawler that responds to SNS Queue messages and crawls some text files in an S3 bucket. 
The bucket has sub-folders that the crawler seems to have identified and created a partition in the table.

I run the crawler manually and it runs with no errors.
The table I get is:

![Athena Table](/media/postImages/original/IMIXlL0euWRo2jX6jvyU_WHg)

`SELECT * FROM "AwsDataCatalog"."xx"."xxxxxxxxx" limit 10;`

However in Athena when I query the table I get:

`HIVE_UNKNOWN_ERROR: iterator path [] not a child of listing path [/] for location [s3://xxxxxxxxxx/]
This query ran against the "gps" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: ff894b94-xxxxx-xxxxxxxx`

Can anyone suggest what I need to do to query succesfully or how to debug this issue ?

Many Thanks
Ted

Giovanni Lauria · Answer

Hello Tedfire,

please verify that the table definition in the Glue Catalogue points to the right S3.
If not, issue this command:

```
ALTER TABLE "AwsDataCatalog"."xx"."xxxxxxxxx" SET LOCATION 's3://correct-path/';
```

Here are some common pitfalls for HIVE:

https://repost.aws/questions/QUsI4ie4iyTxK8xjniUb1ECQ/hive-unknown-error-path-missing-in-file-system-location-s3

AWS Athena against S3 with Sub-folders

Add your answer

Relevant content