tispark icon indicating copy to clipboard operation
tispark copied to clipboard

DateTime and TimeStamp cannot use index when literals are in string format

Open birdstorm opened this issue 6 years ago • 1 comments

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'

birdstorm avatar Aug 27 '18 11:08 birdstorm

can we close it ?

shiyuhang0 avatar Apr 02 '22 07:04 shiyuhang0