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.mcdon...@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
