Hello kylin team, I got a error: " Can't create EnumerableAggregate! while executing SQL: "with cte1 as( select * from (select * from kylin_sales) where seller_id <> 0 ), cte2 as( select distinct trans_id from kylin_sales where trans_id <> 0 ) select part_dt, sum(price) as total_selled, count(distinct seller_id) as seller from cte1 where cte1.trans_id in( select trans_id from cte2) group by part_dt order by part_dt LIMIT 50000" " I ran my SQL as below on sample cube:
with cte1 as( select * from (select * from kylin_sales) where seller_id !=0 ), cte2 as( select distinct trans_id from kylin_sales where trans_id != 0 ) select part_dt, sum(price) as total_selled, count(distinct seller_id) as seller from cte1 where cte1.trans_id in(select trans_id from cte2) group by part_dt order by part_dt does kylin support Subquery with CTE friendly? and could you please give any advise cause it blocked me for a longtime? Thank Yi -- Sent from: http://apache-kylin.74782.x6.nabble.com/