Hello all,
I met a probelm recently when I execute SQL in kylin 2.0.0. When I use the
following sql statement, I got an empty result:
select dt,count(1) from USER_TABLE where cast(dt as date) >= CAST('2016-06-01'
as date) and cast(dt as date) < CAST('2016-06-04' as date) group by dt
dt is varchar type(like '2017-01-01'). But when I use another statement, I got
the correct result:
select dt,count(1) from USER_TABLE where dt >= '2016-06-01' and dt <
'2016-06-04' group by dt
Is this a bug? Or kylin does not supported this kind of sql?
2017-08-24
skyyws
