[
https://issues.apache.org/jira/browse/KYLIN-3643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
May Zhou updated KYLIN-3643:
----------------------------
Description:
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}
{{ }}
{{ {{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}}}}
{{ }}
works good.
But
{{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}}
throws error messages
was:
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}
{{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}}
works good.
But
{{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}}
throws error messages
> 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
> Priority: Critical
>
> 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}
>
> {{ }}
> {{ {{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}}}}
> {{ }}
> works good.
>
> But
>
> {{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}}
> throws error messages
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
