[ https://issues.apache.org/jira/browse/KYLIN-3405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shao Feng Shi closed KYLIN-3405. -------------------------------- Resolution: Not A Problem > kylin mandatory dimension > ------------------------- > > Key: KYLIN-3405 > URL: https://issues.apache.org/jira/browse/KYLIN-3405 > Project: Kylin > Issue Type: Bug > Reporter: Lemont > Priority: Major > > 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 (v8.3.4#803005)