[ https://issues.apache.org/jira/browse/KYLIN-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16621402#comment-16621402 ]
Shaofeng SHI commented on KYLIN-3126: ------------------------------------- Caused by CALCITE-2032; Please uses " d0.year_beg_dt = DATE'2012-01-01' " as a workaround. > Query fails with "Error while compiling generated Java code" when equality > condition is used, and works when equivalent IN clause is specified > ---------------------------------------------------------------------------------------------------------------------------------------------- > > Key: KYLIN-3126 > URL: https://issues.apache.org/jira/browse/KYLIN-3126 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v2.2.0 > Environment: HDP 2.5.6, Kylin 2.2.0, sample cube > Reporter: Vsevolod Ostapenko > Priority: Major > Fix For: v2.6.0 > > > The following query fails with "Error while compiling generated Java code", > when equality condition is used {{(d0.year_beg_dt = '2012-01-01')}} and works > when IN clause is used {{(d0.year_beg_dt in ('2012-01-01'))}} > {code:sql} > select > d2.country, > count(f.item_count) items_ttl > from > kylin_sales f > join > kylin_cal_dt d0 > on > f.part_dt = d0.cal_dt > join > kylin_account d1 > on > f.buyer_id = d1.account_id > join > kylin_country d2 > on > d1.account_country = d2.country > where > d0.year_beg_dt = '2012-01-01' -- blows up > -- d0.year_beg_dt in ('2012-01-01') -- works > and > d2.country in ('US', 'JP') > group by > d2.country > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)