[jira] [Created] (HIVE-13727) Getting error Failed rule: 'orderByClause clusterByClause distributeByClause sortByClause limitClause can only be applied to the whole union.' in subquery

["Rajat Khandelwal (JIRA)" <ji...@apache.org>]

Rajat Khandelwal created HIVE-13727:
---------------------------------------

             Summary: Getting error Failed rule: 'orderByClause clusterByClause distributeByClause sortByClause limitClause can only be applied to the whole union.' in subquery 
                 Key: HIVE-13727
                 URL: https://issues.apache.org/jira/browse/HIVE-13727
             Project: Hive
          Issue Type: Bug
            Reporter: Rajat Khandelwal


The error comes in the following query:
{noformat}
SELECT *
FROM
  (SELECT *
   FROM srcpart a
   WHERE a.ds = '2008-04-08'
     AND a.hr = '11'
   ORDER BY a.key LIMIT 5
   UNION ALL
   SELECT *
   FROM srcpart b
   WHERE b.ds = '2008-04-08'
     AND b.hr = '14'
   ORDER BY b.key LIMIT 5) subq
ORDER BY KEY LIMIT 5
{noformat}

But not in the following query:

{noformat}
SELECT *
FROM
  (SELECT *
   FROM
     (SELECT *
      FROM srcpart a
      WHERE a.ds = '2008-04-08'
        AND a.hr = '11'
      ORDER BY a.key LIMIT 5) pa
   UNION ALL SELECT *
   FROM
     (SELECT *
      FROM srcpart b
      WHERE b.ds = '2008-04-08'
        AND b.hr = '14'
      ORDER BY b.key LIMIT 5) pb) subq
ORDER BY KEY LIMIT 5
{noformat}

The queries are logically identical, the query that's rejected has dummy select * clauses around the sub-queries. 





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)