[ https://issues.apache.org/jira/browse/KYLIN-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vsevolod Ostapenko updated KYLIN-3126: -------------------------------------- Description: 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} was: 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')) 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 > 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 > Assignee: liyang > > 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 (v6.4.14#64029)