[
https://issues.apache.org/jira/browse/HIVE-12646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15363058#comment-15363058
]
Sahil Takiar commented on HIVE-12646:
-------------------------------------
There seem to be a lot of JIRAs related to handling of semi-colons in the query
strings. Here is a brief summary:
HIVE-11100 - added support for Beeline handling of escaped semi-colons - e.g.
{{\;}}
HIVE-9877 - added support for Beeline handling of multiple queries in the same
row, each terminated by a semi-colon
HIVE-12259 - added support for non-escaped semicolons in Beeline commands (e.g.
!cmd)
> 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
>
> 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)
