kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joanna He (Jingke He)" <jingke...@kyligence.io>
Subject Re: Kylin window function
Date Tue, 25 Jul 2017 03:25:03 GMT
The tech blog I referred.
http://kylin.apache.org/blog/2016/11/16/window-function/


何京珂
Joanna He


From: "Joanna He (Jingke He)" <jingke.he@kyligence.io>
Reply-To: "user@kylin.apache.org" <user@kylin.apache.org>
Date: Tuesday, 25 July 2017 at 9:41 AM
To: "user@kylin.apache.org" <user@kylin.apache.org>
Subject: Kylin window function

Anyone familiar with kylin window function? I am trying to get running total of past 12 months
sales based on sql below and I am having difficulties getting the correct syntax.
The tech blog below mentioned kylin syntax follow calcite but on the calcite function page,
it does not specify the syntax within the window.



select g.categ_lvl3_name
,c.month_id
,sum(price) as sales
from KYLIN_Sales s
join KYLIN_CAL_DT c
on s.part_dt=c.cal_dt
join KYLIN_CATEGORY_GROUPINGS g
on s.leaf_categ_id=g.leaf_categ_id
and s.LSTG_SITE_ID=g.SITE_ID
group  by g.categ_lvl3_name, month_id
order by g.categ_lvl3_name,month_id


何京珂
Joanna He

Mime
View raw message