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] [Updated] (KYLIN-2150) detailed subquery + outer query filter will fail

     [ https://issues.apache.org/jira/browse/KYLIN-2150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

hongbin ma updated KYLIN-2150:
------------------------------
    Description: 
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 ) t  where x = '1000121'  group by x,y 

will fail

  was:
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


> 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 ) t  where x = '1000121'  group by x,y 
> will fail



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)