kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Billy Liu <billy...@apache.org>
Subject Re: Kylin window function
Date Tue, 25 Jul 2017 03:31:17 GMT
+ 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
>
>
>

Mime
View raw message