You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2019/01/27 14:58:01 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16753411#comment-16753411 ]
ASF subversion and git services commented on KYLIN-3643:
--------------------------------------------------------
Commit b07575a6f4abbc08363bc52742a527b9225df611 in kylin's branch refs/heads/2.5.x from chao long
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=b07575a ]
KYLIN-3643 Inner column filter can not pushdown
> 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)