sowo commented on issue #24563: URL: https://github.com/apache/superset/issues/24563#issuecomment-2244605513
@ambarishp I've researched this issue and came to the conclusion that pagination of result sets is not supported by Elastic. Elastic SQL does not support the OFFSET clause and the only option it provides is cursor based pagination which only allows you to scroll forward by one page at a time (see https://discuss.elastic.co/t/how-to-use-pagination-in-elastic-search-sql/191135 and https://github.com/elastic/elasticsearch/issues/31549). This is insufficient in the "Drill to details" scenario as Superset allows to skip pages as well as return to previous pages. I am not sure on how to proceed with this as throwing above error is not an acceptable solution either. Maybe @rusackas can chime in here? -- 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]
