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)