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)