carltal opened a new issue, #16877: URL: https://github.com/apache/druid/issues/16877
### Affected Version The Druid version where the problem was encountered: 29.0.1 ### Description Please see the screenshots below. When we have the TIME_PARSE function in both SELECT and WHERE clauses, the output is correct; the column shows null. When we DO NOT have time TIME_PARSE function in both SELECT and WHERE clauses, the output is also correct; the column shows null. However, when we have TIME_PARSE function in SELECT but not in WHERE clause, the column shows "1970-01-01T00:00:00.000Z." The column's type is VARCHAR. We would like to report this finding to Druid developers. Thanks. <img width="1091" alt="query 1" src="https://github.com/user-attachments/assets/79181b69-63a5-4dca-a33a-b49411e66200";> <img width="996" alt="query 2" src="https://github.com/user-attachments/assets/826bacc7-d9f1-4699-a1ba-636545d7e88e";> <img width="174" alt="result 1" src="https://github.com/user-attachments/assets/9d0f29ce-64f2-4d81-a1e3-e613fb37dbc7";> <img width="174" alt="result 2" src="https://github.com/user-attachments/assets/ffe085e1-28cb-407b-9682-d70f7b0a4b1e";> -- 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]
