[jira] [Created] (KYLIN-4738) The order in the returned result is wrong when use window function to query in kylin

["Zhichao Zhang (Jira)" <ji...@apache.org>]

Zhichao  Zhang created KYLIN-4738:
-------------------------------------

             Summary: The order in the returned result is wrong when use window function to query in kylin
                 Key: KYLIN-4738
                 URL: https://issues.apache.org/jira/browse/KYLIN-4738
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v4.0.0-alpha
            Reporter: Zhichao  Zhang
            Assignee: Zhichao  Zhang


Use below sql to query in kylin:
{code:java}
// code placeholder
{code}
SELECT PART_DT, LSTG_FORMAT_NAME, SUM(PRICE) AS GMV,FIRST_VALUE(SUM(PRICE)) OVER(PARTITION BY LSTG_FORMAT_NAME ORDER BY PART_DT) AS "FIRST",LAST_VALUE(SUM(PRICE)) OVER(PARTITION BY LSTG_FORMAT_NAME ORDER BY PART_DT) AS "CURRENT",LAG(SUM(PRICE), 1, 0.0) OVER(PARTITION BY LSTG_FORMAT_NAME ORDER BY PART_DT) AS "PREV",LEAD(SUM(PRICE), 1, 0.0) OVER(PARTITION BY LSTG_FORMAT_NAME ORDER BY PART_DT) AS "NEXT",NTILE(4) OVER (PARTITION BY LSTG_FORMAT_NAME ORDER BY PART_DT) AS "QUARTER"FROM KYLIN_SALESINNER JOIN KYLIN_ACCOUNT as SELLER_ACCOUNTON KYLIN_SALES.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_IDINNER JOIN KYLIN_COUNTRY as SELLER_COUNTRYON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRYWHERE PART_DT >= '2012-12-30' and PART_DT < '2013-01-03' and SELLER_COUNTRY.COUNTRY in ('CN')GROUP BY PART_DT, LSTG_FORMAT_NAMEORDER BY PART_DT LIMIT 5;



--
This message was sent by Atlassian Jira
(v8.3.4#803005)