lwz9103 commented on issue #7032:
URL:
https://github.com/apache/incubator-gluten/issues/7032#issuecomment-2311979648
### Root Cause
If the data type of the filter column is not the same as the data type of
the filter value, Spark will cast the left-side expression.
For example, where t3 in ('2020-10-01 10:10:10', '2020-10-01 10:10:11') will
be converted to where cast(t3 as string) in ('2020-10-01 10:10:10', '2020-10-01
10:10:11').
However, in Gluten Clickhouse, Spark's timestamp type is mapped to
Clickhouse's datetime64(6) type.
So when casting the timestamp column to a string, the value will become
'2020-10-01 10:10:10.000000'.
This is why the filter condition doesn't take effect.
--
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]
