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)

Reply via email to