hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: mismatched input '<EOF>' expecting FROM near 'CURRENT_TIME' in from clause
Date Fri, 20 Jun 2014 08:14:41 GMT
The Hive wiki describes the SELECT syntax here
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-SelectSyntax>
.

-- Lefty


On Thu, Jun 19, 2014 at 9:52 AM, Nitin Pawar <nitinpawar432@gmail.com>
wrote:

> Please take a look at hive's query language support.
>
> its pro-sql but not fully sql compliance
>
>
> On Thu, Jun 19, 2014 at 7:19 PM, Clay McDonald <
> stuart.mcdonald@bateswhite.com> wrote:
>
>> Why does this not work?
>>
>> hive> SELECT CURRENT_TIME;
>> MismatchedTokenException(-1!=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:1194)
>>         at
>> org.apache.hadoop.hive.ql.parse.HiveParser.fromClause(HiveParser.java:31423)
>>         at
>> org.apache.hadoop.hive.ql.parse.HiveParser.selectStatement(HiveParser.java:29520)
>>         at
>> org.apache.hadoop.hive.ql.parse.HiveParser.regular_body(HiveParser.java:29428)
>>         at
>> org.apache.hadoop.hive.ql.parse.HiveParser.queryStatement(HiveParser.java:28968)
>>         at
>> org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpression(HiveParser.java:28762)
>>         at
>> org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:1238)
>>         at
>> org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:938)
>>         at
>> org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:190)
>>         at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:424)
>>         at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:342)
>>         at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1000)
>>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:911)
>>         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:781)
>>         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:39)
>>         at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>>         at java.lang.reflect.Method.invoke(Method.java:597)
>>         at org.apache.hadoop.util.RunJar.main(RunJar.java:212)
>> FAILED: ParseException line 1:19 mismatched input '<EOF>' expecting FROM
>> near 'CURRENT_TIME' in from clause
>>
>
>
>
> --
> Nitin Pawar
>

Mime
View raw message