Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-18513 Query results caching
  3. HIVE-18961

Error in results cache when query has identifiers with spaces

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0
    • Component/s: Query Planning
    • Labels:
      None

      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]
      

        Attachments

        1. HIVE-18961.1.patch
          8 kB
          Jason Dere

          Activity

            People

            • Assignee:
              jdere Jason Dere
              Reporter:
              jdere Jason Dere
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: