A clear and concise description of what the bug is.

1. Drill by any Elasticsearch based chart
2. Click on "2" or Next page

Expected results

Next set of details as per drill-by dimension

Actual results

Error: Error (parsing_exception): {'error': {'root_cause': [{'type': 'parsing_exception', 'reason': "line 64:1: mismatched input 'OFFSET' expecting "}], 'type': 'parsing_exception', 'reason': "line 64:1: mismatched input 'OFFSET' expecting ", 'caused_by': {'type': 'input_mismatch_exception', 'reason': None}}, 'status': 400}

Screenshots

N/A

Environment

• browser type and version: Chrome, Version 114.0.5735.199 (Official Build) (64-bit)
• superset version: 2.1.0
• python version: Python 3.8.17
• node.js version: v12.22.12
• any feature flags active:

DASHBOARD_NATIVE_FILTERS=True
DASHBOARD_CROSS_FILTERS=True
DASHBOARD_NATIVE_FILTERS_SET=True
DASHBOARD_FILTERS_EXPERIMENTAL=True
ALERT_REPORTS=True
OMNIBAR=True
DASHBOARD_RBAC=True
ENABLE_EXPLORE_DRAG_AND_DROP=True
ENABLE_TEMPLATE_PROCESSING=True
VERSIONED_EXPORT=True
THUMBNAILS=True
ENABLE_JAVASCRIPT_CONTROLS=True
DRILL_TO_DETAIL=True
GENERIC_CHART_AXES=True
USE_ANALAGOUS_COLORS=True

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.

Additional context

N/A