Hi Yi,
I have reproduced this issue using the sample dataset of kylin, and I've
opened a JIRA to track this issue.
https://issues.apache.org/jira/browse/KYLIN-3643
Best Regards,
May
--
Sent from: http://apache-kylin.74782.x6.nabble.com/
May Zhou created KYLIN-3643:
---
Summary: Derived column from windowSpec not working in where
Key: KYLIN-3643
URL: https://issues.apache.org/jira/browse/KYLIN-3643
Project: Kylin
Issue Type: Bug
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 subOr