It seems the images cannot be present. So I grabbed part of tables mentioned. >>Table structure looks as:
| 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 | >>(Part)Results returned as: | 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 | | Others | 49.2756 | 186.9764 | 0.0232 | | Others | 49.2756 | 186.9764 | 0.0232 | | Others | 49.2756 | 186.9764 | 0.0232 | | Others | 49.2756 | 186.9764 | 0.0232 | | Others | 49.2756 | 186.9764 | 0.0232 | | Others | 49.2756 | 186.9764 | 0.0232 | | Others | 49.2756 | 186.9764 | 0.0232 | | Others | 49.2756 | 186.9764 | 0.0232 | Does it look more detailed? Best, Luyuan(Adora) At 2016-12-08 10:13:39, "翟鹿渊" <[email protected]> wrote: Hi Kylin Dev team, I used a dataset called learn_kylin, the sample data of table kylin_sales looks like: A problem came when I inputed sql query as: " 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" then replicated results returned. They look like: How does this happen and if there is any way to solve it? Thank you! Luyuan(Adora)
