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.

主题

标签

语言

English

已提问 7 年前900 查看次数

1 回答

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

已接受的回答

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

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

已回答 7 年前