crawled data can not be queried in athena

  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 6 years ago577 views
1 Answer
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:

answered 6 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