You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2016/12/08 13:05:58 UTC

[jira] [Resolved] (KYLIN-2254) A kind of sub-query does not work

     [ https://issues.apache.org/jira/browse/KYLIN-2254?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

liyang resolved KYLIN-2254.
---------------------------
       Resolution: Fixed
         Assignee: liyang
    Fix Version/s: v1.6.1

> 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
>            Assignee: liyang
>             Fix For: v1.6.1
>
>
> 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)