You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Billy Liu (JIRA)" <ji...@apache.org> on 2018/01/24 16:02:00 UTC

[jira] [Resolved] (KYLIN-2630) NPE when a subquery joins another lookup tables

     [ https://issues.apache.org/jira/browse/KYLIN-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Billy Liu resolved KYLIN-2630.
------------------------------
       Resolution: Fixed
    Fix Version/s: v2.0.0

Commit: https://git1-us-west.apache.org/repos/asf?p=kylin.git;a=commit;h=19f9c685

> NPE when a subquery joins another lookup tables
> -----------------------------------------------
>
>                 Key: KYLIN-2630
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2630
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: hongbin ma
>            Assignee: hongbin ma
>            Priority: Major
>             Fix For: v2.0.0
>
>
> {code:sql}
> SELECT t1.cal_dt, t1.sum_price,t1.lstg_site_id 
> FROM (
>   select cal_dt, lstg_site_id, sum(price) as sum_price
>   from test_kylin_fact
>   group by cal_dt, lstg_site_id
>   
> ) t1
> inner JOIN edw.test_cal_dt as test_cal_dt
> on t1.cal_dt=test_cal_dt.cal_dt
> inner JOIN edw.test_sites as test_sites
> on t1.lstg_site_id = test_sites.site_id
> {code}
> throws NPE



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)