hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-12646) beeline and HIVE CLI do not parse ; in quote properly
Date Fri, 29 Jul 2016 08:19:20 GMT

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

Lefty Leverenz commented on HIVE-12646:
---------------------------------------

Should this change be documented in the wiki?  If so, please add a TODOC2.2 label.

* [Beeline – Command Line Shell | https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Beeline–CommandLineShell]
* [Hive CLI | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli]

> beeline and HIVE CLI do not parse ; in quote properly
> -----------------------------------------------------
>
>                 Key: HIVE-12646
>                 URL: https://issues.apache.org/jira/browse/HIVE-12646
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI, Clients
>            Reporter: Yongzhi Chen
>            Assignee: Sahil Takiar
>             Fix For: 2.2.0
>
>         Attachments: HIVE-12646.2.patch, HIVE-12646.3.patch, HIVE-12646.4.patch, HIVE-12646.5.patch,
HIVE-12646.patch
>
>
> Beeline and Cli have to escape ; in the quote while most other shell scripts need not.
For example:
> in Beeline:
> {noformat}
> 0: jdbc:hive2://localhost:10000> select ';' from tlb1;
> select ';' from tlb1;
> 15/12/10 10:45:26 DEBUG TSaslTransport: writing data length: 115
> 15/12/10 10:45:26 DEBUG TSaslTransport: CLIENT: reading data length: 3403
> Error: Error while compiling statement: FAILED: ParseException line 1:8 cannot recognize
input near '<EOF>' '<EOF>
> {noformat}
> while in mysql shell:
> {noformat}
> mysql> SELECT CONCAT(';', 'foo') FROM test limit 3;
> +--------------------+
> | ;foo               |
> | ;foo               |
> | ;foo               |
> +--------------------+
> 3 rows in set (0.00 sec)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message