I've created an issue here: https://issues.apache.org/jira/browse/KYLIN-2820
On Wed, Aug 30, 2017 at 11:19 AM, Kaige Liu <[email protected]> wrote: > It seems to be a bug. Would you please open a JIRA for this issue? Thanks. > > Best regards, > > Kaige Liu(刘凯歌) > Mail: [email protected] > Shanghai Kyligence Information Technology Co., Ltd > 上海市浦东新区亮秀路112号Y1座405室 > > "Do small things with great love." > > > > On 8/30/17, 8:31 AM, "Mu Kong" <[email protected]> wrote: > > Hi, > > I have a question about window function support. > I executed a query like the follows: > > select first_page_name, count(*) as page_name_count from > ( > select first_value(page_name) over(partition by session_id) as > first_page_name from some_db.some_table > ) group by first_page_name; > > > This query resulted in one single record with an empty string as the > first_page_name, and a big number as the page_name_count. > > However, when I ran the subquery along, it resulted in multiple records > with different first_page_name, which proved the query above was wrong. > > I wonder if it is a known issue in kylin right now, and when the window > function in subquery will be fully supported. > > Thanks a lot! > > > Best regards, > Mu > > > >
