1. Use glue to crawl data from s3 file which contains following json ``` {"a":"b", "c":"d"} {"a":"b1", "c":"d2"} ``` 2. The crawler successfully create a table in a database with all the columns recognized 3. Go to athena to query this table, query succeeded, but returns a 0 results. Why does it return 0 results while it should have 2? At the same time there is no error at any step, and the schema is correctly analyzed.

crawled data can not be queried in athena

{"a":"b", "c":"d"}
{"a":"b1", "c":"d2"}

The crawler successfully create a table in a database with all the columns recognized
Go to athena to query this table, query succeeded, but returns a 0 results.

Why does it return 0 results while it should have 2? At the same time there is no error at any step, and the schema is correctly analyzed.

Topics

Tags

Language

English

asked 7 years ago890 views

1 Answer

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

Accepted Answer

OK, the problem is with how you define the source s3.

The s3 can not be a single file, but a dir.

answered 7 years ago