You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jason Dere (JIRA)" <ji...@apache.org> on 2018/03/14 21:22:00 UTC
[jira] [Commented] (HIVE-18961) Error in results cache when query
has identifiers with spaces
[ https://issues.apache.org/jira/browse/HIVE-18961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16399438#comment-16399438 ]
Jason Dere commented on HIVE-18961:
-----------------------------------
One solution is to quote all identifiers in the query string used as the cache key. Attaching patch.
> Error in results cache when query has identifiers with spaces
> -------------------------------------------------------------
>
> Key: HIVE-18961
> URL: https://issues.apache.org/jira/browse/HIVE-18961
> Project: Hive
> Issue Type: Sub-task
> Components: Query Planning
> Reporter: Jason Dere
> Assignee: Jason Dere
> Priority: Major
> Attachments: HIVE-18961.1.patch
>
>
> Found by [~gopalv]:
> {noformat}
> 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]
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)