By using AWS re:Post, you agree to the Terms of Use

crawled data can not be queried in athena

0
  1. Use glue to crawl data from s3 file which contains following json
{"a":"b", "c":"d"}
{"a":"b1", "c":"d2"}
  1. The crawler successfully create a table in a database with all the columns recognized
  2. 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.

asked 5 years ago54 views
1 Answer
0
Accepted Answer

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

answered 5 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions