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/07 10:34:58 UTC

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

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)