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

Posted to issues@kylin.apache.org by "Chao Long (JIRA)" <ji...@apache.org> on 2018/12/26 06:28:00 UTC

[jira] [Resolved] (KYLIN-3643) Derived column from windowSpec not working in where

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

Chao Long resolved KYLIN-3643.
------------------------------
    Resolution: Fixed

> Derived column from windowSpec not working in where
> ---------------------------------------------------
>
>                 Key: KYLIN-3643
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3643
>             Project: Kylin
>          Issue Type: Bug
>         Environment: Kylin 2.5.0
>            Reporter: May Zhou
>            Assignee: Chao Long
>            Priority: Critical
>             Fix For: v2.6.0
>
>
> Derived column from windowSpec not working in where with error message of 
> {quote}-1 while executing SQL: "SELECT * FROM ( SELECT ROW_NUMBER() OVER ( PARTITION BY BUYER_ID,SELLER_ID ORDER BY PRICE ) AS ROW_NUM ,TRANS_ID ,BUYER_ID ,PRICE ,SELLER_ID ,PART_DT FROM KYLIN_SALES ) T WHERE T.ROW_NUM =1 LIMIT 50000"
>  taking kylin sample dataset as an example,
> {quote}
>  Here I've taken kylin sample dataset as example.
> {quote} 
>  SELECT ROW_NUMBER() OVER (
>  PARTITION BY BUYER_ID,SELLER_ID ORDER BY PRICE
>  ) AS ROW_NUM
>  ,TRANS_ID
>  ,BUYER_ID
>  ,PRICE
>  ,SELLER_ID
>  ,PART_DT
>  FROM KYLIN_SALES
>   
> {quote}
>  works good.
>  
> But 
>  
> {quote}SELECT *
>  FROM (
>  SELECT ROW_NUMBER() OVER (
>  PARTITION BY BUYER_ID,SELLER_ID ORDER BY PRICE
>  ) AS ROW_NUM
>  ,TRANS_ID
>  ,BUYER_ID
>  ,PRICE
>  ,SELLER_ID
>  ,PART_DT
>  FROM KYLIN_SALES
>  ) T
>  WHERE T.ROW_NUM =1
> {quote}
> throws error messages
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)