[jira] [Updated] (HIVE-26175) single quote in a comment causes parsing errors

2022-04-26 Thread renjianting (Jira)


 [ 
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: 

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: 

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}


> 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: 
> 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)


[jira] [Updated] (HIVE-26175) single quote in a comment causes parsing errors

2022-04-26 Thread renjianting (Jira)


 [ 
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: 

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 

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}


> 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: 
> 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)


[jira] [Updated] (HIVE-26175) single quote in a comment causes parsing errors

2022-04-26 Thread renjianting (Jira)


 [ 
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)
  

[jira] [Updated] (HIVE-26175) single quote in a comment causes parsing errors

2022-04-26 Thread renjianting (Jira)


 [ 
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 
{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)
   

[jira] [Updated] (HIVE-26175) single quote in a comment causes parsing errors

2022-04-25 Thread ASF GitHub Bot (Jira)


 [ 
https://issues.apache.org/jira/browse/HIVE-26175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

ASF GitHub Bot updated HIVE-26175:
--
Labels: pull-request-available  (was: )

> 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: 10m
>  Remaining Estimate: 0h
>
> 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@[201:64: ( ( KW_AS )? alias= identifier )?]) 
>  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.tableSource(HiveParser_FromClauseParser.java:4220)
>   at 
> org.apache.hadoop.hive.ql.parse.HiveParser_FromClauseParser.atomjoinSource(HiveParser_FromClauseParser.java:1602)
>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:45020)  
>   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)   
>