Hello Kylin Team, When I ran " with subOrder1 as ( select MEMBERID as groupColumn, row_number() over(partition by SUBSCRIBERFLAG order by SUBSCRIBERFLAG Asc) rn1 from TBLPFTEST500W_SMALL) select groupColumn, rn1 from subOrder1 where rn1 = 1"
I got a error: " -1 while executing SQL: "with subOrder1 as ( select MEMBERID as groupColumn, row_number() over(partition by SUBSCRIBERFLAG order by SUBSCRIBERFLAG Asc) rn1 from TBLPFTEST500W_SMALL ) select * from subOrder1 where rn1 =1 LIMIT 50000 " but it is good without "where rn1 = 1" Thanks Yi -- Sent from: http://apache-kylin.74782.x6.nabble.com/
