+ Yerui. Do you have any idea? 2017-07-25 11:25 GMT+08:00 Joanna He (Jingke He) <jingke...@kyligence.io>:
> The tech blog I referred. > > http://kylin.apache.org/blog/2016/11/16/window-function/ > > > > > > 何京珂 > > Joanna He > > > > > > *From: *"Joanna He (Jingke He)" <jingke...@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 > > >
