liyang created KYLIN-2254:
-----------------------------
Summary: A kind of sub-query does not work
Key: KYLIN-2254
URL: https://issues.apache.org/jira/browse/KYLIN-2254
Project: Kylin
Issue Type: Bug
Reporter: liyang
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
