elasticsearch-sql
elasticsearch-sql copied to clipboard
NLPchina
Paging does not work with aggregation query by command OFFSET ... LIMIT ...
Paging does not work with query:
SELECT *, COUNT(*) FROM users GROUP BY city OFFSET 10 LIMIT 10
ES does not support paging for aggregation query, but elasticsearch-sql can be support fake paging for aggregation query in memory. Please support the feature. Thanks
Caching result query in memory may crash user's application ,or may even crash ES. Also this behavior can cause some confusion in people who lack of basic search engine concept.
I don't need caching in memory. Just simple paging on result list by command OFFSET ... LIMIT ...
Ex:
SELECT *, COUNT(*) FROM users GROUP BY city OFFSET 10 LIMIT 10
Total may be 1000 documents but I need the result list must be 10 documents from OFFSET 10
+1 (is there an alternative such as NOT IN (), in such way at least we can exclude the docs in the first offset?)
