tispark
tispark copied to clipboard
DateTime and TimeStamp cannot use index when literals are in string format
We could change the literal string into timestamp type, or push down casted filter so that index could be used correctly.
e.g.,
select tp_datetime from t where tp_datetime between '2000-01-01 00:00:00' and timestamp '2001-01-01 00:00:00'
select tp_datetime from t where tp_datetime between '2018' and date '2019-01-01'
can we close it ?