You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Szehon Ho (JIRA)" <ji...@apache.org> on 2015/10/22 03:09:27 UTC

[jira] [Commented] (HIVE-11100) Beeline should escape semi-colon in queries

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

Szehon Ho commented on HIVE-11100:
----------------------------------

Hey [~ctang.ma] [~xuefuz], wondering if you realized that this is backward compatible for connect strings that involve semicolon, for example connecting to security or dynamic service discovery?

eg, beeline -u 'jdbc:hive2://localhost:10000/default;principal=hive/host@realm'
beeline -u "jdbc:hive2://localhost:2181/\;serviceDiscoveryMode=zooKeeper\;zooKeeperNamespace=hiveserver2"

> 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
>             Fix For: 1.3.0, 2.0.0
>
>         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)