KSPT-taylorjohn opened a new issue, #25073: URL: https://github.com/apache/superset/issues/25073
The chart series limit setting doesn't work for Clickhouse datasets. The generated SQL doesn't contain a limit subquery. #### How to reproduce the bug 1. Use a clickhouse db 2. Create a chart with a dimension 3. Add a series limit 4. Note how the series aren't limited in the generated SQL ### Expected results The generated query to use the series limit. ### Actual results The generated query doesn't use the series limit. #### Screenshots  ### Environment - browser type and version: Firefox 102.14.0esr - superset version: docker latest-dev (using docker-compose-non-dev.yml) - python version: Python 3.9.17 - any feature flags active: FEATURE_FLAGS = {"ALERT_REPORTS": True, "HORIZONTAL_FILTER_BAR": True, "DRILL_TO_DETAIL": True, "DRILL_BY": 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. -- 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: notifications-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org