[HIVE-11100] Beeline should escape semi-colon in queries

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.1.0, 1.2.0
• Fix Version/s: 1.3.0, 2.0.0
• Component/s: Beeline
• Assignee: Chaoyu Tang
• Reporter: Chaoyu Tang
• Created: 24/Jun/15 21:28
• Updated: 22/Feb/17 12:34
• Resolved: 30/Jun/15 17:44

Description

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.

Issue Links

• is depended upon by: HIVE-15820 comment at the head of beeline -e
• is related to: SPARK-12014 Spark SQL query containing semicolon is broken in Beeline (related to HIVE-11100)
• is related to: HIVE-9877 Beeline cannot run multiple statements in the same row
• relates to: HIVE-12259 Command containing semicolon is broken in Beeline
• relates to: HIVE-12646 beeline and HIVE CLI do not parse ; in quote properly
• relates to: SPARK-12497 thriftServer does not support semicolon in sql