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
