Sorry for my mistake. It should be "use CAST in where clause" not "CASE"
2017-08-24 skyyws 发件人："skyyws"<[email protected]> 发送时间：2017-08-24 20:41 主题：SQL execute failed when use CASE in where clause 收件人："dev"<[email protected]> 抄送： 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
