[ https://issues.apache.org/jira/browse/HIVE-13727?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez updated HIVE-13727: ------------------------------------------- Fix Version/s: (was: 2.1.0) > 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 the following query works: > {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)