tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hyunsik Choi (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TAJO-418) sort operator after Inline views consisting of unions can cause an incorrect distributed plan
Date Sun, 15 Dec 2013 16:21:06 GMT
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)

Mime
View raw message