[HIVE-23898] Query fails if identifier contains double quotes or semicolon char

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CLI, Parser
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Krisztian Kasa
• Reporter: Krisztian Kasa
• Created: 22/Jul/20 11:50
• Updated: 27/Feb/24 22:23
• Resolved: 24/Jul/20 01:14

Description

CREATE TABLE `t;`(a int);

[ERROR]   TestMiniLlapLocalCliDriver.testCliDriver:62 Client execution failed with error code = 40000 
running 
CREATE TABLE `t 
fname=test.q

See ./ql/target/tmp/log/hive.log or ./itests/qtest/target/tmp/log/hive.log, or check ./ql/target/surefire-reports or ./itests/qtest/target/surefire-reports/ for specific test cases logs.
 org.apache.hadoop.hive.ql.parse.ParseException: line 2:15 character '<EOF>' not supported here

CREATE TABLE `t"`(a int);

[ERROR] Failures: 
[ERROR]   TestMiniLlapLocalCliDriver.testCliDriver:62 Client execution failed with error code = 40000 
running 

CREATE TABLE `t"`(a int);
 
fname=test.q

See ./ql/target/tmp/log/hive.log or ./itests/qtest/target/tmp/log/hive.log, or check ./ql/target/surefire-reports or ./itests/qtest/target/surefire-reports/ for specific test cases logs.
 org.apache.hadoop.hive.ql.parse.ParseException: line 3:24 extraneous input ';' expecting EOF near '<EOF>'

Issue Links

• is related to: HIVE-19064 Add mode to support delimited identifiers enclosed within double quotation
• links to: GitHub Pull Request #1295