[
https://issues.apache.org/jira/browse/HIVE-11100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14604479#comment-14604479
]
Chaoyu Tang commented on HIVE-11100:
------------------------------------
[~xuefuz] CLI uses ";" to terminate a command, or delimit multiple commands in
a single line. If ";" is used in a query, it has to be escaped with "\".
Beeline uses ";" to terminate a command, HIVE-9877 enhanced Beeline to support
multiple commands separated by ";" in a single line, this JIRA adds the support
that ";" in a query could be escaped by "\".
So both JIRAs are trying to make Beeline more compatible to CLI in term of the
use of ";". Actually their implementations are also similar.
> Beeline should escape semi-colon in queries
> -------------------------------------------
>
> Key: HIVE-11100
> URL: https://issues.apache.org/jira/browse/HIVE-11100
> Project: Hive
> Issue Type: Bug
> Components: Beeline
> Affects Versions: 1.2.0, 1.1.0
> Reporter: Chaoyu Tang
> Assignee: Chaoyu Tang
> Priority: Minor
> Attachments: HIVE-11100.patch
>
>
> Beeline should escape the semicolon in queries. for example, the query like
> followings:
> CREATE TABLE beeline_tb (c1 int, c2 string) ROW FORMAT DELIMITED FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\n';
> or
> CREATE TABLE beeline_tb (c1 int, c2 string) ROW FORMAT DELIMITED FIELDS
> TERMINATED BY '\;' LINES TERMINATED BY '\n';
> both failed.
> But the 2nd query with semicolon escaped with "\" works in CLI.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
