kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shaofeng SHI (JIRA)" <j...@apache.org>
Subject [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
Date Fri, 14 Sep 2018 03:52:00 GMT

     [ 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)

Mime
View raw message