dosubot[bot] commented on issue #33551: URL: https://github.com/apache/superset/issues/33551#issuecomment-2899039373
<!-- Answer --> The issue you're experiencing with alias mutation when using `clickhouse-connect` in Apache Superset is a known limitation. The mutation of metric labels, such as `max(number) AS max_n_23e7d4`, prevents the use of aliases in subsequent expressions, which is a powerful feature in ClickHouse. This behavior differs from `clickhouse_driver`, where aliases can be referenced directly. Currently, there isn't a documented workaround for this specific issue in the Superset repository. However, you might consider manually adjusting the SQL queries to avoid relying on mutated aliases or exploring if there are configuration options in `clickhouse-connect` that could alter this behavior. Additionally, keeping an eye on updates to the `clickhouse-connect` library or Superset might provide a future solution. <!-- 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/178d2a88-6c7a-4054-8c8e-ca796bcab0c2?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/178d2a88-6c7a-4054-8c8e-ca796bcab0c2?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/178d2a88-6c7a-4054-8c8e-ca796bcab0c2?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/178d2a88-6c7a-4054-8c8e-ca796bcab0c2?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/178d2a88-6c7a-4054-8c8e-ca796bcab0c2?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/178d2a88-6c7a-4054-8c8e-ca796bcab0c2?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/178d2a88-6c7a-4054-8c8e-ca796bcab0c2?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]
