Lemont created KYLIN-3405: ----------------------------- Summary: kylin mandatory dimension Key: KYLIN-3405 URL: https://issues.apache.org/jira/browse/KYLIN-3405 Project: Kylin Issue Type: Bug Reporter: Lemont
I created a simple cube on kylin 2.3.1,the table has three dimensions:pt,biz_time and periods_time ,one measure :online_rider Something trouble me is that when i set biz_time to the mandatory dimension,the sql will execute fail. The sql is : select floor((1524931200 - biz_time)/(30*86400)), count(DISTINCT online_rider) onlineRiders from rider_view where pt = '20180530' and periods_time in(0) and biz_time >1524931200 group by floor((1524931200 - biz_time)*1.0/(30*86400)) . The error is : null while executing sql. But when I remove the condition of periods_time in(0) or floor function the sql will execute success. I don't know what's the relationship between the two. -- This message was sent by Atlassian JIRA (v7.6.3#76005)