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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

JIRA jira@apache.org
hongbin ma created KYLIN-2630:
---------------------------------

             Summary: 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


{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
(v6.3.15#6346)
Loading...