bkyryliuk commented on issue #27957: URL: https://github.com/apache/superset/issues/27957#issuecomment-2313374884
I took a closer look into it and looks like issue happens here: https://github.com/apache/superset/blob/d80f23ed948e9f9111af7a10c4cf6708a30af1d4/superset/models/helpers.py#L872 and it is most likely databricks sqlalchemy connector bug ``` query_obj: {'apply_fetch_values_predicate': False, 'columns': [], 'extras': {'having': '', 'where': ''}, 'filter': [], 'from_dttm': None, 'granularity': None, 'inner_from_dttm': None, 'inner_to_dttm': None, 'is_rowcount': False, 'is_timeseries': False, 'metrics': [{'aggregate': None, 'column': None, 'datasourceWarning': False, 'expressionType': 'SQL', 'hasCustomLabel': False, 'label': 'MAX(IF ts > 1000, 0.14, 0.11)', 'optionName': 'metric_9xsakmcbifl_jnw2h0nolw', 'sqlExpression': 'MAX(IF ts > 1000, 0.14, 0.11)'}], 'order_desc': True, 'orderby': [], 'row_limit': 50000, 'row_offset': 0, 'series_columns': [], 'series_limit': 0, 'series_limit_metric': None, 'to_dttm': None, 'time_shift': None} sqla_query: SELECT MAX(IF ts > 1000, 0.14, 0.11) AS "MAX(IF ts > 1000, 0.14, 0.11)" FROM "default".my_table LIMIT :param_1 sql SELECT 14, 0.11) AS `MAX(IF ts > 1000, 0.14, 0.11)` FROM `default`.`my_table` LIMIT 50000 ``` -- 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]
