[KYLIN-2254] A kind of sub-query does not work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v2.0.0
• Assignee: liyang
• Reporter: liyang
• Created: 07/Dec/16 10:34
• Updated: 30/Apr/17 12:21
• Resolved: 08/Dec/16 13:05

Description

For example below query does not work.

SELECT
f.lstg_format_name
,sum(price) as sum_price
FROM
test_kylin_fact f
inner join
(
select
lstg_format_name,
min(slr_segment_cd) as min_seg
from
test_kylin_fact
group by
lstg_format_name
) t on f.lstg_format_name = t.lstg_format_name
where
f.slr_segment_cd = min_seg
group by
f.lstg_format_name

Issue Links

• is related to: KYLIN-2467 TPC-H queries run on Kylin