You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2014/09/01 08:42:20 UTC
[jira] [Commented] (TAJO-1023) Filter may be omitted when same
aliased tables are used in inline views.
[ https://issues.apache.org/jira/browse/TAJO-1023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14117084#comment-14117084 ]
ASF GitHub Bot commented on TAJO-1023:
--------------------------------------
GitHub user hyunsik opened a pull request:
https://github.com/apache/tajo/pull/129
TAJO-1023: Filter may be omitted when same aliased tables are used in inline views.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/hyunsik/tajo TAJO-1023
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/129.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #129
----
commit a57cc9c903859f3c59efbf13fb63bf1add03c996
Author: Hyunsik Choi <hy...@apache.org>
Date: 2014-09-01T05:48:21Z
Fixed filter push down bug.
commit 17ce782cabeef7ae89b05eea700f14e8624850f6
Author: Hyunsik Choi <hy...@apache.org>
Date: 2014-09-01T05:48:36Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into FILTER_PUSHDOWN
commit 98f09e2b37bf396cff875ae7a7ef8649ad028d00
Author: Hyunsik Choi <hy...@apache.org>
Date: 2014-09-01T06:40:32Z
Removed comments.
----
> Filter may be omitted when same aliased tables are used in inline views.
> ------------------------------------------------------------------------
>
> Key: TAJO-1023
> URL: https://issues.apache.org/jira/browse/TAJO-1023
> Project: Tajo
> Issue Type: Bug
> Components: planner/optimizer
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Priority: Minor
> Fix For: 0.9.0
>
>
> The following query reproduces the problem mentioned in subject. In this case, {{a.row_num >= 3}} disappears during filter push down rewrite.
> {code}
> select
> a.r_name, a.row_num
> from (
> select
> r_name,
> r_regionkey,
> row_number() over (order by r_name) as row_num
> from
> region a
> ) a join region b on a.r_regionkey = b.r_regionkey
> where
> a.row_num >= 3;
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)