You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2018/09/14 03:52:00 UTC
[jira] [Updated] (KYLIN-3126) Query fails with "Error while
compiling generated Java code" when equality condition is used, and works
when equivalent IN clause is specified
[ https://issues.apache.org/jira/browse/KYLIN-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI updated KYLIN-3126:
--------------------------------
Fix Version/s: v2.6.0
> 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: Roger Shi
> 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)