[
https://issues.apache.org/jira/browse/KYLIN-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Luyuan Zhai updated KYLIN-2258:
-------------------------------
Attachment: sample_data.png
A sample data image
> sql query(avg/min/max over) result turns to be replicated
> ---------------------------------------------------------
>
> Key: KYLIN-2258
> URL: https://issues.apache.org/jira/browse/KYLIN-2258
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Environment: windows
> Reporter: Luyuan Zhai
> Assignee: liyang
> Priority: Minor
> Attachments: sample_data.png
>
>
> Situation: I inputed sql query following then results turned right yet with
> duplicates. It seems the over(partition by clause) doesn't work.
> >>data source:learn_kylin
> table kylin_sales looks like:
>
> Row | TRANS_ID | PART_DT | LSTG_FORMAT_NAME | LEAF_CATEG_ID | LSTG_SITE_ID |
> SLR_SEGMENT_CD | PRICE | ITEM_COUNT | SELLER_ID | USER_ID | REGION |
> | 1 | 0 | 2012-12-14 | Others | 88750 | 0 | 11 | 36.2828 | 0 | 10000349 |
> ANALYST | Beijing |
> >>sql query like:
> select LSTG_FORMAT_NAME, avg(price) over(partition by LSTG_FORMAT_NAME) as
> price_level, max(price) over(partition by LSTG_FORMAT_NAME) as price_max,
> min(price) over(partition by LSTG_FORMAT_NAME) as price_min from kylin_sales
> >>results returns as: (you can find this file attached)
> LSTG_FORMAT_NAME PRICE_LEVEL PRICE_MAX PRICE_MIN
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
> FP-non GTC 49.81376 145.495 0.0537
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
