[HIVE-18961] Error in results cache when query has identifiers with spaces

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Query Planning
• Assignee: Jason Dere Assign to me
• Reporter: Jason Dere
• Created: 14/Mar/18 20:57
• Updated: 22/May/18 23:15
• Resolved: 15/Mar/18 22:12

Description

Found by Gopal Vijayaraghavan:

2018-03-14T05:08:32,551 ERROR [0c4b7a6c-ed37-428e-ac04-ca38716f211e HiveServer2-HttpHandler-Pool: Thread-8961]: parse.CalcitePlanner (:()) - Unexpected ]
org.apache.hadoop.hive.ql.parse.ParseException: line 1:100 missing EOF at 'Count' near 'IMSI'
        at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:220) ~[hive-exec-3.0.0.3.0.0.2-132-jdere.jar:3.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.ql.parse.ParseUtils.parse(ParseUtils.java:74) ~[hive-exec-3.0.0.3.0.0.2-132-jdere.jar:3.0.0-SNAPSHOT]
        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getQueryStringForCache(SemanticAnalyzer.java:14067) ~[hive-exec-3.0.0.3.0.0.2-132-jdere.jar:]
        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.createLookupInfoForQuery(SemanticAnalyzer.java:14080) ~[hive-exec-3.0.0.3.0.0.2-132-jdere.ja]
        at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:11683) ~[hive-exec-3.0.0.3.0.0.2-132-jdere.jar:3.0.0-S]
        at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:304) ~[hive-exec-3.0.0.3.0.0.2-132-jdere.jar:3.0.0-SNAPSHO]
        at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:273) ~[hive-exec-3.0.0.3.0.0.2-132-jdere.jar:3.0.0-SNA]
        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:614) ~[hive-exec-3.0.0.3.0.0.2-132-jdere.jar:3.0.0-SNAPSHOT]