[jira] [Commented] (HIVE-26175) Fixed ParseException caused by unpaired quotation marks in a line of comments

["Alessandro Solimando (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-26175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17528676#comment-17528676 ] 

Alessandro Solimando commented on HIVE-26175:
---------------------------------------------

Somehow my reply got lost! I tried the query you suggest with the "-f" option and it does not fail on current master.

To set it up I used [https://github.com/kgyrtkirk/hive-dev-box], in case you want to double check by yourself.

From within the repo's folder after git clone:
{code:java}
./hdb run master{code}
Within the container the final setup is as follows:

 
{code:java}
# in /home/dev:
git clone git@github.com:apache/hive.git
git checkout master
git config --local extra.ideProjects ql,common
cd hive
rebuild # builds hive
sw hadoop 3.1.0
sw tez 0.10.0
sw hive-dev # this uses the code you have cloned and built right above
reinit_metastore
hive_launch
{code}
The last command launches a screen session including a terminal and beeline, you can run "hive -f test.sql" from the terminal tab after creating the file.

If you manage to repro this please share the steps you followed (if different from the ones above), and I'd be happy to take a look, [~renjianting001].

 

> Fixed ParseException caused by unpaired quotation marks in a line of comments
> -----------------------------------------------------------------------------
>
>                 Key: HIVE-26175
>                 URL: https://issues.apache.org/jira/browse/HIVE-26175
>             Project: Hive
>          Issue Type: Bug
>          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
>
> Unpaired quotation marks in a line of comments causes ParseException ： 
> 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)