crawled data can not be queried in athena
0
- Use glue to crawl data from s3 file which contains following json
{"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.
질문됨 7년 전900회 조회
1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
0
OK, the problem is with how you define the source s3.
The s3 can not be a single file, but a dir.
refer to this doc for using Glue Crawlers: https://docs.aws.amazon.com/glue/latest/dg/crawler-s3-folder-table-partition.html
답변함 7년 전
Thank you for this. It answered my question