[
https://issues.apache.org/jira/browse/HIVE-11100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14602327#comment-14602327
]
Chaoyu Tang commented on HIVE-11100:
------------------------------------
Since Hive 0.14, Beeline supports multiple commands separated by ";" in a
single line passed in via -f or -e, which break the case with ";" in sql query.
This JIRA is to provide an escape "\" to the ";' in query, so that it will
behave same as CLI.
> 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
>
> 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)
