You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Vsevolod Ostapenko (JIRA)" <ji...@apache.org> on 2017/12/22 00:14:00 UTC
[jira] [Created] (KYLIN-3126) Query fails with "Error while
compiling generated Java code" when equality condition is used, and works
when equivalent IN clause is specified
Vsevolod Ostapenko created KYLIN-3126:
-----------------------------------------
Summary: 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'))
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
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)