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
