GreatAg opened a new issue, #25039:
URL: https://github.com/apache/superset/issues/25039
I connected superset to my elasticsearch instance and created a dataset.
I created a chart table in order to view all of my logs but because of my
dataset is huge i need server side pagination.
When i enabled server side pagination feature i faced an error.
and here is query output:
Here is my other chart configurations:
I think the second query doesn't have a correct syntax and LIMIT 50000
shouldn't be there.
Please let me know if anyone can help me in order to solve this problem.
### Expected results
A table with server side pagination.
### Actual results
I faced following error:
Error: Error (planning_exception): {'error': {'root_cause': [{'type':
'planning_exception', 'reason': 'Found 1 problem\nline 16:4: LIMIT or TOP
cannot be used in a subquery if outer query contains GROUP BY, ORDER BY, PIVOT
or WHERE'}], 'type': 'planning_exception', 'reason': 'Found 1 problem\nline
16:4: LIMIT or TOP cannot be used in a subquery if outer query contains GROUP
BY, ORDER BY, PIVOT or WHERE'}, 'status': 400}
### Environment
- browser type and version: chrome 113.0.0
- superset version: 2.1.1
- python version: 3.9.17
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included
it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version
of superset.
- [x] I have checked the issue tracker for the same issue and I haven't
found one similar.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
