[
https://issues.apache.org/jira/browse/KYLIN-2340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liyang resolved KYLIN-2340.
---------------------------
Resolution: Fixed
Fix Version/s: v2.0.0
> 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
> Fix For: v2.0.0
>
>
> 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)
