[
https://issues.apache.org/jira/browse/KYLIN-2340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liyang updated KYLIN-2340:
--------------------------
Description:
E.g. this one:
{code}
select
lstg_format_name,
sum(price) as gvm
from
(
select
cal_dt,
lstg_format_name,
price
from test_kylin_fact
inner JOIN test_category_groupings
ON test_kylin_fact.leaf_categ_id =
test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id =
test_category_groupings.site_id
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
where
lstg_site_id = 0
and cal_dt > '2013-05-13'
) f
where
lstg_format_name ='Auction'
group by
lstg_format_name
{code}
was:
E.g. this one:
select
lstg_format_name,
sum(price) as gvm
from
(
select
cal_dt,
lstg_format_name,
price
from test_kylin_fact
inner JOIN test_category_groupings
ON test_kylin_fact.leaf_categ_id =
test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id =
test_category_groupings.site_id
inner JOIN edw.test_sites as test_sites
ON test_kylin_fact.lstg_site_id = test_sites.site_id
where
lstg_site_id = 0
and cal_dt > '2013-05-13'
) f
where
lstg_format_name ='Auction'
group by
lstg_format_name
> Some subquery returns incorrect result
> --------------------------------------
>
> Key: KYLIN-2340
> URL: https://issues.apache.org/jira/browse/KYLIN-2340
> Project: Kylin
> Issue Type: Bug
> Reporter: liyang
> Assignee: liyang
>
> E.g. this one:
> {code}
> select
> lstg_format_name,
> sum(price) as gvm
> from
> (
> select
> cal_dt,
> lstg_format_name,
> price
> from test_kylin_fact
> inner JOIN test_category_groupings
> ON test_kylin_fact.leaf_categ_id =
> test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id =
> test_category_groupings.site_id
> inner JOIN edw.test_sites as test_sites
> ON test_kylin_fact.lstg_site_id = test_sites.site_id
> where
> lstg_site_id = 0
> and cal_dt > '2013-05-13'
> ) f
> where
> lstg_format_name ='Auction'
> group by
> lstg_format_name
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
