[
https://issues.apache.org/jira/browse/HIVE-26175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
renjianting updated HIVE-26175:
-------------------------------
Description:
A single quote in a comment causes parsing errors： such as
task.sql
{code:java}
select 1 -- comment I'm col1"xxx
;
select 2 -- comment I'm col2"xxx
; {code}
The following error occurs when i run a similar task using the "hive -f
task.sql" command :
{code:java}
FAILED: ParseException line 2:0 cannot recognize input near '1' ';' 'select' in
constant{code}
was:
A single quote in a comment causes parsing errors： such as
{code:java}
select 1 -- I'm xxx
from tbl; {code}
Running a task like this will result in the following error：
{code:java}
NoViableAltException(377@[96:1: atomjoinSource : ( tableSource ( lateralView
^)* | virtualTableSource ( lateralView ^)* | ( LPAREN ( KW_WITH | KW_SELECT |
KW_MAP | KW_REDUCE | KW_FROM ) )=> subQuerySource ( lateralView ^)* | ( LPAREN
LPAREN atomSelectStatement RPAREN setOperator )=> subQuerySource ( lateralView
^)* | partitionedTableFunction ( lateralView ^)* | LPAREN ! joinSource RPAREN
!);]) at
org.antlr.runtime.DFA.noViableAlt(DFA.java:158)
at
org.antlr.runtime.DFA.predict(DFA.java:116)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.atomjoinSource(HiveParser_FromClauseParser.java:1593)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.joinSource(HiveParser_FromClauseParser.java:1903)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.fromSource(HiveParser_FromClauseParser.java:1527)
at
org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.fromClause(HiveParser_FromClauseParser.java:1370)
at
org.apache.hadoop.hive.ql.parse.HiveParser.fromClause(HiveParser.java:45322)
at
org.apache.hadoop.hive.ql.parse.HiveParser.atomSelectStatement(HiveParser.java:39792)
at
org.apache.hadoop.hive.ql.parse.HiveParser.selectStatement(HiveParser.java:40044)
at
org.apache.hadoop.hive.ql.parse.HiveParser.regularBody(HiveParser.java:39690)
at
org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpressionBody(HiveParser.java:38900)
at
org.apache.hadoop.hive.ql.parse.HiveParser.queryStatementExpression(HiveParser.java:38788)
at
org.apache.hadoop.hive.ql.parse.HiveParser.execStatement(HiveParser.java:2396)
at
org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:1420)
at
org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:220)
at
org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:74)
at
org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:67)
at
org.apache.hadoop.hive.ql.Driver.compile(Driver.java:616)
at
org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1826)
at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1773)
at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1768)
at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:214)
at
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:239)
at
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:188)
at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:402)
at
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:335)
at
org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:471)
at
org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:487)
at
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:793)
at
org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759)
at
org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:683)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at
java.lang.reflect.Method.invoke(Method.java:498)
at
org.apache.hadoop.util.RunJar.run(RunJar.java:323)
at
org.apache.hadoop.util.RunJar.main(RunJar.java:236)
FAILED: ParseException line
2:8 cannot recognize input near 'tbl' ';' '' in joinSource {code}
> single quote in a comment causes parsing errors
> -----------------------------------------------
>
> Key: HIVE-26175
> URL: https://issues.apache.org/jira/browse/HIVE-26175
> Project: Hive
> Issue Type: Improvement
> Components: CLI, Parser
> Affects Versions: 3.1.3
> Reporter: renjianting
> Assignee: renjianting
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Time Spent: 1h 10m
> Remaining Estimate: 0h
>
> A single quote in a comment causes parsing errors： such as
> task.sql
> {code:java}
> select 1 -- comment I'm col1"xxx
> ;
>
> select 2 -- comment I'm
> col2"xxx
> ; {code}
> The following error occurs when i run a similar task using the "hive -f
> task.sql" command :
> {code:java}
> FAILED: ParseException line 2:0 cannot recognize input near '1' ';' 'select'
> in constant{code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
