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.

Sujets

Balises

Langue

English

demandé il y a 7 ans900 vues

1 réponse

Ces réponses sont-elles utiles ? Votez pour la bonne réponse pour aider la communauté à bénéficier de vos connaissances.

Réponse acceptée

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

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

répondu il y a 7 ans