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/

Reply via email to