netliteIT opened a new issue, #27382: URL: https://github.com/apache/superset/issues/27382
### Bug description Importing a public data set or using a dataset on an external DB using "ts" TIMESTAMP WITH TIME ZONE, works fine but using wizard to manage a simple timerange produce an empty result. ### How to reproduce the bug https://preset.io/blog/timeseries-cratedb-superset/ Follow the guide and set a filter on ts like that:  Looks like the query has a .0 at the ond of timestamps which is not understood by internal superset engine and by external DB. This is the query generated by SuperSet: SELECT DATE_TRUNC('day', ts) AS ts, sum("Global_active_power") AS "SUM(Global_active_power)" FROM doc.power_consumption WHERE ts >= 1172707200000.0 AND ts < 1206748800000.0 GROUP BY DATE_TRUNC('day', ts) ORDER BY "SUM(Global_active_power)" DESC LIMIT 10000 ### Screenshots/recordings _No response_ ### Superset version 3.1.1 ### Python version 3.9 ### Node version 16 ### Browser Firefox ### Additional context _No response_ ### Checklist - [X] I have searched Superset docs and Slack and didn't find a solution to my problem. - [X] I have searched the GitHub issue tracker and didn't find a similar bug report. - [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- 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]
