rvazquezglez opened a new issue #16223: URL: https://github.com/apache/superset/issues/16223
I have created a query for Trino DB using SQL explorer, one of the columns is a time column (`timestamp(3) with time zone` type on Trino), if I try to apply a time filter over that column (either the same SQL explorer or a filter box on a dashboard), I'm getting this error: ``` Error: line 19:19: Cannot apply operator: timestamp(3) with time zone <= varchar(26) ``` ### Expected results Date filter applied and get results ### Actual results Getting an error. #### Screenshots  #### How to reproduce the bug 1. Setup a connection to a Trino instance 2. Visualize a table with a timestamp or date column 3. Try to apply a date or timestamp filter 4. See error ### Environment - superset version: `1.2.0` - python version: `3.8` - node.js version: `not present` - any feature flags active: not activated any. ### Checklist Make sure to follow these steps before submitting your issue - thank you! - [X] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [X] I have reproduced the issue with at least the latest released version of superset. - [X] I have checked the issue tracker for the same issue and I haven't found one similar. ### Additional context I believe that's because [Trino (formerly PrestoSQL) doesn't automatically convert `VARCHAR` to `TIMESTAMP` or `DATE`](https://stackoverflow.com/a/38041684/1195507) -- 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]
