You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2013/12/15 17:31:07 UTC

[jira] [Updated] (TAJO-418) sort operator after Inline views consisting of unions can cause an incorrect distributed plan

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

Hyunsik Choi updated TAJO-418:
------------------------------

    Status: Patch Available  (was: Open)

> sort operator after Inline views consisting of unions can cause an incorrect distributed plan
> ---------------------------------------------------------------------------------------------
>
>                 Key: TAJO-418
>                 URL: https://issues.apache.org/jira/browse/TAJO-418
>             Project: Tajo
>          Issue Type: Bug
>          Components: distributed query plan
>            Reporter: Hyunsik Choi
>            Assignee: Hyunsik Choi
>             Fix For: 0.8-incubating
>
>         Attachments: TAJO-418.patch
>
>
> See the title. The following query is an example of this bug.
> {code}
> SELECT
>   l_returnflag,
>   l_linestatus
> FROM (
>   SELECT
>     *
>   FROM
>     lineitem
>   WHERE
>     l_returnflag = 'O'
>   UNION ALL
>   SELECT
>     *
>   FROM
>     lineitem
>   WHERE
>     l_returnflag = 'R'
> ) T
> GROUP BY
>   l_returnflag,
>   l_linestatus
> ORDER BY
>   l_returnflag,
>   l_linestatus
> {code}
> This patch adds an unit test to reproduce this case and includes the bug fix.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)