You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "hongbin ma (JIRA)" <ji...@apache.org> on 2016/11/02 09:30:58 UTC

[jira] [Created] (KYLIN-2150) detailed subquery + outer query filter will fail

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)