Lars Francke created HIVE-4933:
----------------------------------
Summary: Can't use alias directly before OVER clause
Key: HIVE-4933
URL: https://issues.apache.org/jira/browse/HIVE-4933
Project: Hive
Issue Type: Bug
Affects Versions: 0.11.0
Reporter: Lars Francke
Priority: Minor
{code}
CREATE TABLE test (foo INT);
hive (default)> SELECT foo AS foobar OVER (PARTITION BY foo) FROM test;
MismatchedTokenException(171!=107)
at
org.antlr.runtime.BaseRecognizer.recoverFromMismatchedToken(BaseRecognizer.java:617)
at org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.fromClause(HiveParser_FromClauseParser.java:1191)
at
org.apache.hadoop.hive.ql.parse.HiveParser.fromClause(HiveParser.java:31353)
at
org.apache.hadoop.hive.ql.parse.HiveParser.selectStatement(HiveParser.java:29429)
at
org.apache.hadoop.hive.ql.parse.HiveParser.regular_body(HiveParser.java:29337)
at
org.apache.hadoop.hive.ql.parse.HiveParser.queryStatement(HiveParser.java:28877)
at
org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpression(HiveParser.java:28671)
at
org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1235)
at
org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:935)
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:190)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:422)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:341)
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:965)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:880)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:413)
at
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:782)
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:614)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
FAILED: ParseException line 1:21 mismatched input 'OVER' expecting FROM near
'foobar' in from clause
{code}
The same happens without the {{AS}}.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
