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

Sahil Takiar commented on HIVE-12646:
-------------------------------------

Seems {{TestHiveCli.testInValidCmd}} was failing. There were some differences 
between how the original code split on the ; and how the new code iterated 
through the line and searched for a ;. These differences have been addressed 
and a new diff has been uploaded.

> 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
>         Attachments: HIVE-12646.2.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)

Reply via email to