dosubot[bot] commented on issue #31974: URL: https://github.com/apache/superset/issues/31974#issuecomment-2609982588
<!-- Greeting --> Hey @Phyks! I'm here to assist you with any bugs, questions, or contributions. Let's tackle this issue together! <!-- Answer --> The issue you're experiencing with duplicate columns when using a SQL function in the Y-axis configuration for heatmaps in Superset 4.1.1 seems to be related to changes in the heatmap SQL query generation logic. While I couldn't find specific details about changes in version 4.1 that might cause this, the SQL query generation for heatmaps is handled by the `buildQuery` function in the file `superset-frontend/plugins/plugin-chart-echarts/src/Heatmap/buildQuery.ts` <sup>[[1]](https://github.com/apache/superset/blob/master/superset-frontend/plugins/plugin-chart-echarts/src/Heatmap/buildQuery.ts)</sup>. The expected behavior when using SQL functions in axis configurations is that the SQL expression should be supported and incorporated into the query without causing duplication <sup>[[2]](https://github.com/apache/superset/blob/master/superset-frontend/packages/superset-ui-core/test/query/normalizeTimeColumn.test.ts)</sup>. However, it seems there might be a bug affecting this functionality in your case. Since you're using Spark with the Apache Hive connector, it's also possible that there might be specific issues or limitations with this setup, although I couldn't find any documented ones related to heatmaps. To address this, you might want to check the `buildQuery` logic for any recent changes or consider creating a minimal reproducible example to further investigate the issue. <!-- 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/120c834c-8fb0-4b1c-bac2-6be2c02ed03e?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/120c834c-8fb0-4b1c-bac2-6be2c02ed03e?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/120c834c-8fb0-4b1c-bac2-6be2c02ed03e?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/120c834c-8fb0-4b1c-bac2-6be2c02ed03e?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/120c834c-8fb0-4b1c-bac2-6be2c02ed03e?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/120c834c-8fb0-4b1c-bac2-6be2c02ed03e?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]
