EUbaldiEC commented on issue #31974: URL: https://github.com/apache/superset/issues/31974#issuecomment-4073531168
Bumping this for your consideration as we nailed down the issue - which is still persistent but only triggered when turning on y-scale / x-scale sorting. **Superset version** 6.0.0 (within container image docker.io/apache/spark:4.0.2-scala2.13-java21-python3-ubuntu ) Installed via `pipx install apache-superset==6.0.0` **Python version** 3.10 **Node version** 18 or greater **Browser** Firefox **Additional context** The issue is present when working in a heatmap plot, with a hive parquet dataset and using an sql column with a renaming involved as: `REPLACE(category, 'STATEMENT_CATEGORY_', '')` The data are correctly displayed fine if no axis sorting is set. Interestingly, also the normalisation across x-y axis works as expected and does not raise any duplicated column issue: <img width="676" height="548" alt="Image" src="https://github.com/user-attachments/assets/926b21ba-5dd7-47b4-aab2-886b2647ad76"; /> However, as soon as axis sorting is set on y-axis (or likewise x-axis if the column is set as x), the following error will appear: ``` Error: TExecuteStatementResp(status=TStatus(statusCode=3, infoMessages=["*org.apache.hive.service.cli.HiveSQLException:Error running query: [UNRESOLVED_COLUMN.WITH_SUGGESTION] org.apache.spark.sql.AnalysisException: [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column, variable, or function parameter with name `My column` cannot be resolved. Did you mean one of the following? [`My column`, `My column`, `total_count`, `platform_name`, `platform_name`]. SQLSTATE: 42703; line 43 pos 2;\n'GlobalLimit 10000\n+- 'LocalLimit 10000\n +- 'Sort [platform_name#4164 ASC NULLS FIRST, 'My column ASC NULLS FIRST], true ... ``` I'm using Spark as a datasource, with Apache Hive connector. The issue is not present when doing the same procedure on a sql dataset in the example sets (like the [flights dataset](https://raw.githubusercontent.com/apache-superset/examples-data/master/tutorial_flights.csv)). <img width="475" height="500" alt="Image" src="https://github.com/user-attachments/assets/7a253212-cb61-4a02-b499-6ea5c31ed6e6"; /> Happy to provide more context if needed, thanks! -- 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]
