dosubot[bot] commented on issue #29409: URL: https://github.com/apache/superset/issues/29409#issuecomment-2200255181
<!-- Answer --> To resolve the "Limit reached" error in Apache Superset version 4.0.1, ensure that the following configurations are set correctly in your `superset_config.py` file: 1. **Set the maximum number of rows to display in SQLLab:** ```python DISPLAY_MAX_ROW = 10000 # Adjust this value as needed ``` 2. **Set the maximum number of rows returned for any analytical database query:** ```python SQL_MAX_ROW = 100000 # Adjust this value as needed ``` 3. **Set the default row limit for SQL Lab queries:** ```python DEFAULT_SQLLAB_LIMIT = 1000 # Adjust this value as needed ``` Additionally, verify that these configurations are being applied correctly in the backend and frontend code: - **Backend**: Ensure the `apply_display_max_row_limit` function in `superset/views/utils.py` and the `execute_sql_statement` function in `superset/sql_lab.py` are using these values correctly <sup>[[1]](https://github.com/apache/superset/blob/master/superset/views/utils.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/sql_lab.py)</sup>. - **Frontend**: Ensure the `displayLimit` and `defaultQueryLimit` props in the `ResultSet` component in `superset-frontend/src/SqlLab/components/ResultSet/index.tsx` are set appropriately <sup>[[3]](https://github.com/apache/superset/blob/master/superset-frontend/src/SqlLab/components/ResultSet/index.tsx)</sup>. After making these changes, restart your Superset server to apply the new settings. This should help manage the row limits effectively and resolve the "Limit reached" error. Additionally, you might find these similar issues and discussions helpful: - [Issue #22485](https://github.com/apache/superset/issues/22485): Suggests modifying the `superset_config_docker.py` file to increase the row limit for charts. - [Issue #28644](https://github.com/apache/superset/issues/28644): Recommends using Apache Superset version 3.1.3 or 4.0.1, as the bug was fixed in these versions. - [Issue #26779](https://github.com/apache/superset/issues/26779): Resolved by a pull request that fixed the hardcoded row limit in the UI. - [Issue #22569](https://github.com/apache/superset/issues/22569): Suggests updating to the latest version of Superset, as the issue has been fixed in the latest release. These steps and resources should help you address the row limit issue in SQLLab. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- 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]
