Missing results from Athena query
When I do the query "SELECT * FROM sellers WHERE seller_id = 'x'", the results are returned where the seller_id is equal to 'x', when I do "SELECT * FROM sellers", and try to search the row in Athena using the filter, the row is not there, I have unloaded the data to inspect, and it is not there. Why can Athena return the row when the seller_id is specified, but doesn't for the general query?
The data is stored in s3, in parquet files, and glue is used to crawl the data to create the schema.
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
Hi,
I'm not 100% certain but I suspect that the filter functionality in the console ("Search rows") only works on the amount of data that was returned to the browser. In your case, it's very unlikely that all 669,462 lines would have been loaded into the UI (to conserve bandwidth, memory and so on). That means that this filter/search only works on the subset of data that is currently loaded into your browsers memory. On the other hand, the SQL statement applies the filter directly to the query and returns only a much smaller subset.
Relevanter Inhalt
AWS OFFICIALAktualisiert vor einem Jahr- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 3 Jahren