zhaoyongjie commented on issue #25749: URL: https://github.com/apache/superset/issues/25749#issuecomment-1779379248
@martin-raymond I'm wondering it might be a bug in Apache Calcite side because it can't correctly calculate expression `DATETIMECONVERT((startDate/1000), '1:SECONDS:EPOCH', '1:SECONDS:EPOCH', '1:SECONDS')`. There is a workaround might be useful, 1) try to create a derived column based on the _startDate_ in Pinot as `timestamp` type instead of `long` type, 2) then **remove** epoch_ms tag in column config, 3), syncing column metadata in Dataset Model in Superset. 4) use the new derived column replace with previous one in Chart. Hope it helps you. -- 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]
