Hi all,
This is my first post to developers' mailing list.
I have a question about the behavior of HiveServer2.
When HiveServer2 parse invalid syntaxes sent from beeline2, it prints an
ParseException in console output.
Example code is below.
----------------------------------
Input:
hostA$ hiveserver2
hostB$ beeline -u jdbc:hive2://localhost:10000 -n user -p pass -e "invalid
syntax;"
Output:
hostA$ NoViableAltException(26@[])
[0/1248]
at
org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1108)
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:204)
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:444)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:319)
at
org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1199)
at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1186)
at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:146)
at
org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:218)
...
FAILED: ParseException line 1:0 cannot recognize input near 'invalid'
'syntax' '<EOF>'
=> Is it correct?
hostB$ Error: Error while compiling statement: FAILED: ParseException line
1:0 cannot recognize input near 'invalid' 'syntax' '<EOF>'
(state=42000,code=40000)
=> correct.
----------------------------------
I feel strange about this behavior that it throws exception, because the
input text is invalid syntax but isn't an unexpected input.
Is this correct design? If not, I will create the JIRA ticket and address
this issue to suppress the exception output.
Thanks!
--
Takuma Wakamori
[email protected]