[
https://issues.apache.org/jira/browse/HIVE-15822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16514462#comment-16514462
]
Vineet Garg edited comment on HIVE-15822 at 6/15/18 10:38 PM:
--------------------------------------------------------------
This particular scenario is already fixed in Hive 3.0 by HIVE-16935.
{code:sql}
-e "
show databases;--some comment here
show tables;"
{code}
Beeline executes both {{show databases}} and {{show tables}} after removing
comments.
was (Author: vgarg):
This particular scenario is already fixed by HIVE-16935.
{code:sql}
-e "
show databases;--some comment here
show tables;"
{code}
Beeline executes both {{show databases}} and {{show tables}} after removing
comments.
> beeline ignore all sql under comment after semicolon
> ----------------------------------------------------
>
> Key: HIVE-15822
> URL: https://issues.apache.org/jira/browse/HIVE-15822
> Project: Hive
> Issue Type: Bug
> Components: Beeline, HiveServer2
> Affects Versions: 1.2.1, 2.1.1
> Reporter: muxin
> Assignee: muxin
> Priority: Major
> Attachments: HIVE-15822.patch
>
>
> way to reproduce this error:
> beeline -u jdbc:hive2://localhost:10000 -n test -e "
> show databases;--some comment here
> show tables;"
> it will only execute 'show databases', and consider
> '--some comment here
> show tables;'
> as comment( all sql under the first comment appeared after semicolon).
> when the comment is also end with semicolon, the result will be right.
> the root cause is that beeline will only consider a entire command is inputed
> when a line is end with semicolon, otherwise if this line is not started with
> '--' or '#' beeline will combine it with next line until meet semicolon in
> the end. so actually the comment above is not removed(which causes the
> error). then beeline split the entire line by ';', so 'show databases' is
> recognized and executed,
> '--some comment here\n show tables' is considered a comment and discarded.
> my solution is to just remove comment before split by ';', the code can refer
> to solution 2 for similar issue
> :https://issues.apache.org/jira/browse/HIVE-15820
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
