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

Tez: union all followed by group by followed by another union all gives error

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.14.0
    • 1.1.0
    • Tez
    • None

    Description

      Here is the way to produce it:

      in Hive q test setting (with src table)

      set hive.execution.engine=tez;

      select key from
      (
      select key from src
      union all
      select key from src
      ) tab group by key
      union all
      select key from src;

      will give you

      ERROR
      2014-12-09 11:38:48,316 ERROR ql.Driver (SessionState.java:printError(834)) - FAILED: IndexOutOfBoundsException Index: -1, Size: 1
      java.lang.IndexOutOfBoundsException: Index: -1, Size: 1
      at java.util.LinkedList.checkElementIndex(LinkedList.java:553)
      at java.util.LinkedList.get(LinkedList.java:474)
      at org.apache.hadoop.hive.ql.parse.GenTezWork.process(GenTezWork.java:354)
      at org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:90)
      at org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatchAndReturn(DefaultGraphWalker.java:94)
      at org.apache.hadoop.hive.ql.parse.GenTezWorkWalker.walk(GenTezWorkWalker.java:87)
      at org.apache.hadoop.hive.ql.parse.GenTezWorkWalker.walk(GenTezWorkWalker.java:103)
      at org.apache.hadoop.hive.ql.parse.GenTezWorkWalker.walk(GenTezWorkWalker.java:103)
      at org.apache.hadoop.hive.ql.parse.GenTezWorkWalker.walk(GenTezWorkWalker.java:103)
      at org.apache.hadoop.hive.ql.parse.GenTezWorkWalker.walk(GenTezWorkWalker.java:103)
      at org.apache.hadoop.hive.ql.parse.GenTezWorkWalker.startWalking(GenTezWorkWalker.java:69)
      at org.apache.hadoop.hive.ql.parse.TezCompiler.generateTaskTree(TezCompiler.java:368)
      at org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:202)
      at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:10202)
      at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:221)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:420)
      at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:306)
      at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1108)
      at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1170)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1045)
      at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1035)
      at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:199)
      at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:151)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:362)
      at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:297)
      at org.apache.hadoop.hive.ql.QTestUtil.executeClient(QTestUtil.java:834)
      at org.apache.hadoop.hive.cli.TestMiniTezCliDriver.runTest(TestMiniTezCliDriver.java:136)
      at org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_uniontez(TestMiniTezCliDriver.java:120)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

      btw: there is not problem when it is run with MR

      Attachments

        1. HIVE-9055.1.patch
          3 kB
          Vikram Dixit K
        2. HIVE-9055.2.patch
          3 kB
          Vikram Dixit K
        3. HIVE-9055.3.patch
          9 kB
          Vikram Dixit K

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            vikram.dixit Vikram Dixit K Assign to me
            pxiong Pengcheng Xiong
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment