Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-7635

Query having same aggregate functions but different case throws IndexOutOfBoundsException

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.13.1
    • Fix Version/s: 0.14.0
    • Component/s: Query Processor
    • Labels:
      None

      Description

      A query having same aggregate functions (e.g. count) but in different case does not work and throws IndexOutOfBoundsException.

      Query:
      SELECT key, COUNT(value) FROM src GROUP BY key HAVING count(value) >= 4
      ---
      Error log:
      14/08/06 11:00:45 ERROR ql.Driver: FAILED: IndexOutOfBoundsException Index: 2, Size: 2
      java.lang.IndexOutOfBoundsException: Index: 2, Size: 2
      	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
      	at java.util.ArrayList.get(ArrayList.java:322)
      	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genGroupByPlanReduceSinkOperator(SemanticAnalyzer.java:4173)
      	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genGroupByPlanMapAggrNoSkew(SemanticAnalyzer.java:5165)
      	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:8337)
      	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:9178)
      	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9431)
      	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:207)
      	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:414)
      	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:310)
      	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1023)
      	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1088)
      	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:960)
      	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:950)
      	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:265)
      	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:217)
      	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:427)
      	at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800)
      	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694)
      	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633)
      

        Attachments

        1. HIVE-7635.1.patch
          9 kB
          Chaoyu Tang
        2. HIVE-7635.patch
          5 kB
          Chaoyu Tang

          Activity

            People

            • Assignee:
              ctang Chaoyu Tang
              Reporter:
              ctang Chaoyu Tang
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: