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:21:06 UTC

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

Hyunsik Choi created TAJO-418:
---------------------------------

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


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)