Nicolas Richard created HIVE-27649:
--------------------------------------
Summary: Subqueries with a set operator do not support order by
statements
Key: HIVE-27649
URL: https://issues.apache.org/jira/browse/HIVE-27649
Project: Hive
Issue Type: Bug
Components: Parser
Affects Versions: 3.1.2, 4.0.0
Reporter: Nicolas Richard
Consider the following query:
{code:java}
select key from ((select key from src order by key) union (select key from
src))subq {code}
Up until 3.1.2, Hive would parse this query without any problems. However, if
you try it on the latest versions, you'll get the following exception:
{code:java}
org.apache.hadoop.hive.ql.parse.ParseException: line 1:60 cannot recognize
input near 'union' '(' 'select' in subquery source
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:125)
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:97) {code}
With the inner exception stack trace being:
{code:java}
NoViableAltException(367@[])
at
org.apache.hadoop.hive.ql.parse.HiveParser_IdentifiersParser.identifier(HiveParser_IdentifiersParser.java:14006)
at
org.apache.hadoop.hive.ql.parse.HiveParser.identifier(HiveParser.java:45086)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.subQuerySource(HiveParser_FromClauseParser.java:5411)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.atomjoinSource(HiveParser_FromClauseParser.java:1921)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.joinSource(HiveParser_FromClauseParser.java:2175)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.atomjoinSource(HiveParser_FromClauseParser.java:2110)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.joinSource(HiveParser_FromClauseParser.java:2175)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.fromSource(HiveParser_FromClauseParser.java:1750)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.fromClause(HiveParser_FromClauseParser.java:1593)
at
org.apache.hadoop.hive.ql.parse.HiveParser.fromClause(HiveParser.java:45094)
at
org.apache.hadoop.hive.ql.parse.HiveParser.atomSelectStatement(HiveParser.java:38538)
at
org.apache.hadoop.hive.ql.parse.HiveParser.selectStatement(HiveParser.java:38831)
at
org.apache.hadoop.hive.ql.parse.HiveParser.regularBody(HiveParser.java:38424)
at
org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpressionBody(HiveParser.java:37686)
at
org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpression(HiveParser.java:37574)
at
org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:2757)
at
org.apache.hadoop.hive.ql.parse.HiveParser.explainStatement(HiveParser.java:1751)
at
org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1614)
at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:123)
at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:97)
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
