hongbin ma created KYLIN-2150: --------------------------------- Summary: detailed subquery + outer query filter will fail Key: KYLIN-2150 URL: https://issues.apache.org/jira/browse/KYLIN-2150 Project: Kylin Issue Type: Bug Reporter: hongbin ma Assignee: liyang
select x,y from (select cast(seller_id as varchar(10)) x, trans_date_2 y from fact01_v group by cast(seller_id as varchar(10)) , trans_date_2) t where x = '1000121' group by x,y will succeed, select x, y from (select cast(seller_id as varchar) x, trans_date_2 y from fact01_v ) t group by x,y will succeed too. However select x,y from (select cast(seller_id as varchar(10)) x, trans_date_2 y from fact01_v group ) t where x = '1000121' group by x,y will fail -- This message was sent by Atlassian JIRA (v6.3.4#6332)