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/20 01:47:00 UTC
[jira] [Commented] (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: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)