+ Yerui. Do you have any idea?

2017-07-25 11:25 GMT+08:00 Joanna He (Jingke He) <jingke.he@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.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