Re: cast string column to date in where clause

2020-07-29 Thread Yaqian Zhang
Hi: Can you provide the detail query log? SegmentPruner may prune the segment by mistake for some reason. > 在 2020年7月22日,19:54,skyyws 写道: > > Hello everyone, > Recently when I use Kylin to query like this: > select dt from table > where cast(dt as date) >= cast('2020-07-21' as date) and

cast string column to date in where clause

2020-07-22 Thread skyyws
Hello everyone, Recently when I use Kylin to query like this: select dt from table where cast(dt as date) >= cast('2020-07-21' as date) and cast(dt as date) <= cast('2020-07-22' as date) group by dt; The result is null, but when I use this query: select dt from table where dt >= '2020-07-21' and