dosubot[bot] commented on issue #32367: URL: https://github.com/apache/superset/issues/32367#issuecomment-2680006769
<!-- Answer --> To address the issue with Superset 4.1.1 assuming that Apache Pinot supports JOINs by default, you can configure Superset to explicitly disable JOIN operations for databases that do not support them. This can be done by setting the `allows_joins` attribute to `False` in the database configuration. This will prevent Superset from attempting JOIN operations that are not supported by your current Pinot setup <sup>[[1]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/README.md)</sup>. Additionally, if you are using a version of Pinot that supports the multi-stage engine, you can enable it by adding the following argument in the database connection settings under Advanced -> Other -> ENGINE PARAMETERS: ```json {"connect_args":{"use_multistage_engine":"true"}} ``` This will allow Superset to perform JOIN operations if the multi-stage engine is available and enabled <sup>[[2]](https://github.com/apache/superset/blob/master/docs/docs/configuration/databases.mdx)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/235cd251-b619-4b6a-a900-67e51d611d4e?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/235cd251-b619-4b6a-a900-67e51d611d4e?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/235cd251-b619-4b6a-a900-67e51d611d4e?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/235cd251-b619-4b6a-a900-67e51d611d4e?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/235cd251-b619-4b6a-a900-67e51d611d4e?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/235cd251-b619-4b6a-a900-67e51d611d4e?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/235cd251-b619-4b6a-a900-67e51d611d4e?feedback_type=other)</sup> -- 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]
