Hive
  1. Hive
  2. HIVE-6403

uncorrelated subquery is failing with auto.convert.join=true

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: Query Processor
    • Labels:
      None
    • Release Note:
      Hide
      also added to 0.13
      thanks Navis
      Show
      also added to 0.13 thanks Navis

      Description

      Fixing HIVE-5690, I've found query in subquery_multiinsert.q is not working with hive.auto.convert.join=true

      set hive.auto.convert.join=true;
      hive> explain
          > from src b 
          > INSERT OVERWRITE TABLE src_4 
          >   select * 
          >   where b.key in 
          >    (select a.key 
          >     from src a 
          >     where b.value = a.value and a.key > '9'
          >    ) 
          > INSERT OVERWRITE TABLE src_5 
          >   select *  
          >   where b.key not in  ( select key from src s1 where s1.key > '2') 
          >   order by key 
          > ;
      java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
      	at java.util.ArrayList.rangeCheck(ArrayList.java:635)
      	at java.util.ArrayList.get(ArrayList.java:411)
      	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinLocalWork(MapJoinProcessor.java:149)
      	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genLocalWorkForMapJoin(MapJoinProcessor.java:256)
      	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinOpAndLocalWork(MapJoinProcessor.java:248)
      	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.convertTaskToMapJoinTask(CommonJoinTaskDispatcher.java:191)
      	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.processCurrentTask(CommonJoinTaskDispatcher.java:481)
      	at org.apache.hadoop.hive.ql.optimizer.physical.AbstractJoinTaskDispatcher.dispatch(AbstractJoinTaskDispatcher.java:182)
      	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.dispatch(TaskGraphWalker.java:111)
      	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.walk(TaskGraphWalker.java:194)
      	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.startWalking(TaskGraphWalker.java:139)
      	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinResolver.resolve(CommonJoinResolver.java:79)
      	at org.apache.hadoop.hive.ql.optimizer.physical.PhysicalOptimizer.optimize(PhysicalOptimizer.java:100)
      	at org.apache.hadoop.hive.ql.parse.MapReduceCompiler.optimizeTaskPlan(MapReduceCompiler.java:290)
      	at org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:216)
      	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9167)
      	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327)
      	at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:64)
      	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327)
      	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:446)
      	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:346)
      	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1056)
      	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1099)
      	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:992)
      	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:982)
      	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)
      	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
      	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:424)
      	at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:793)
      	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:687)
      	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:626)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
      org.apache.hadoop.hive.ql.parse.SemanticException: Failed to generate new mapJoin operator by exception : Index: 0, Size: 0
      	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genLocalWorkForMapJoin(MapJoinProcessor.java:266)
      	at org.apache.hadoop.hive.ql.optimizer.MapJoinProcessor.genMapJoinOpAndLocalWork(MapJoinProcessor.java:248)
      	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.convertTaskToMapJoinTask(CommonJoinTaskDispatcher.java:191)
      	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinTaskDispatcher.processCurrentTask(CommonJoinTaskDispatcher.java:481)
      	at org.apache.hadoop.hive.ql.optimizer.physical.AbstractJoinTaskDispatcher.dispatch(AbstractJoinTaskDispatcher.java:182)
      	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.dispatch(TaskGraphWalker.java:111)
      	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.walk(TaskGraphWalker.java:194)
      	at org.apache.hadoop.hive.ql.lib.TaskGraphWalker.startWalking(TaskGraphWalker.java:139)
      	at org.apache.hadoop.hive.ql.optimizer.physical.CommonJoinResolver.resolve(CommonJoinResolver.java:79)
      	at org.apache.hadoop.hive.ql.optimizer.physical.PhysicalOptimizer.optimize(PhysicalOptimizer.java:100)
      	at org.apache.hadoop.hive.ql.parse.MapReduceCompiler.optimizeTaskPlan(MapReduceCompiler.java:290)
      	at org.apache.hadoop.hive.ql.parse.TaskCompiler.compile(TaskCompiler.java:216)
      	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:9167)
      	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327)
      	at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(ExplainSemanticAnalyzer.java:64)
      	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:327)
      	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:446)
      	at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:346)
      	at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1056)
      	at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1099)
      	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:992)
      	at org.apache.hadoop.hive.ql.Driver.run(Driver.java:982)
      	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)
      	at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
      	at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:424)
      	at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:793)
      	at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:687)
      	at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:626)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:606)
      	at org.apache.hadoop.util.RunJar.main(RunJar.java:160)
      FAILED: SemanticException Generate Map Join Task Error: Failed to generate new mapJoin operator by exception : Index: 0, Size: 0
      
      1. HIVE-6403.1.patch
        24 kB
        Harish Butani
      2. navis.patch
        4 kB
        Navis
      3. HIVE-6403.2.patch
        26 kB
        Harish Butani
      4. navis2.patch
        97 kB
        Navis
      5. HIVE-6403.3.patch.txt
        71 kB
        Navis
      6. HIVE-6403.4.patch.txt
        75 kB
        Navis
      7. HIVE-6403.5.patch.txt
        119 kB
        Navis
      8. HIVE-6403.6.patch.txt
        119 kB
        Navis

        Issue Links

          Activity

          Hide
          Navis added a comment -

          I wish I could fix this but it's way out of my ability. Could you check this Harish Butani ?

          Show
          Navis added a comment - I wish I could fix this but it's way out of my ability. Could you check this Harish Butani ?
          Hide
          Harish Butani added a comment -

          Navis I am no expert on the MapJoinProcessor. Following is what I see; I will need to spend more time on this.
          Maybe from my comments you can see the issue.

          1. The Plan generated at genPlan is:
          TS[0] (the scan for b) has 2 child operators: [RS[4], RS[25]]
          These are for the joins for each of the SubQuery expressions:
          b.key in
          (select a.key
          from src a
          where b.value = a.value and a.key > '9'
          )
          and
          b.key not in ( select key from src s1 where s1.key > '2')

          The plan looks complex because the handling of not in requires the null check. This issue will occur even if the second insert is a 'in' subquery predicate. It will be easier to follow for such an e.g.

          2. With set hive.auto.convert.join=false
          The second RS gets converted to a FileSink. You can observe this from the explain output. A subsequent Stage reads this intermediate output to perform the processing for the 2nd SubQuery.

          3. With set hive.auto.convert.join=true;
          When it comes to CommonJoinResolver the TS[0] has children [RS[4], FS[44]] ie the 2nd ReduceSink is converted to a FileSink
          The MapJoinProcessor:genMapJoinLocalWork line 145 it is assuming that a TableScanOp can only have 1 child.
          The fix maybe to ignore any FileSink operators that are children of TableScan. Another test to add is a multi insert on 3 tables.

          Show
          Harish Butani added a comment - Navis I am no expert on the MapJoinProcessor. Following is what I see; I will need to spend more time on this. Maybe from my comments you can see the issue. 1. The Plan generated at genPlan is: TS [0] (the scan for b) has 2 child operators: [RS [4] , RS [25] ] These are for the joins for each of the SubQuery expressions: b.key in (select a.key from src a where b.value = a.value and a.key > '9' ) and b.key not in ( select key from src s1 where s1.key > '2') The plan looks complex because the handling of not in requires the null check. This issue will occur even if the second insert is a 'in' subquery predicate. It will be easier to follow for such an e.g. 2. With set hive.auto.convert.join=false The second RS gets converted to a FileSink. You can observe this from the explain output. A subsequent Stage reads this intermediate output to perform the processing for the 2nd SubQuery. 3. With set hive.auto.convert.join=true; When it comes to CommonJoinResolver the TS [0] has children [RS [4] , FS [44] ] ie the 2nd ReduceSink is converted to a FileSink The MapJoinProcessor:genMapJoinLocalWork line 145 it is assuming that a TableScanOp can only have 1 child. The fix maybe to ignore any FileSink operators that are children of TableScan. Another test to add is a multi insert on 3 tables.
          Hide
          Harish Butani added a comment -

          Navis could you please review.

          Show
          Harish Butani added a comment - Navis could you please review.
          Hide
          Navis added a comment -

          I think CommonJoinTaskDispatcher#getPosition() depends on wrong assumption that top operator has only a child (or resultingly a child like LV cases). We should track up (child to parent) big aliases from bigTableCandidates, opposed to current way.

          Show
          Navis added a comment - I think CommonJoinTaskDispatcher#getPosition() depends on wrong assumption that top operator has only a child (or resultingly a child like LV cases). We should track up (child to parent) big aliases from bigTableCandidates, opposed to current way.
          Hide
          Harish Butani added a comment -

          What I see is that for the Multi Insert with SubQuery case:

          • the first child will be a ReduceSink; other child is converted to FileSink by the time it gets to CommonJoinTaskDispatcher.
          • so for the Multi Insert SubQuery case checking the first child is still ok.

          But yes this check that other children are FileSink, should be done in CommonJoinTaskDispatcher#getPosition

          Beyond the above point; I am sorry, I don't follow what else you are proposing. Can you please elaborate.

          Show
          Harish Butani added a comment - What I see is that for the Multi Insert with SubQuery case: the first child will be a ReduceSink; other child is converted to FileSink by the time it gets to CommonJoinTaskDispatcher. so for the Multi Insert SubQuery case checking the first child is still ok. But yes this check that other children are FileSink, should be done in CommonJoinTaskDispatcher#getPosition Beyond the above point; I am sorry, I don't follow what else you are proposing. Can you please elaborate.
          Hide
          Navis added a comment -

          This is the change what I've meant. Could you check this?

          Show
          Navis added a comment - This is the change what I've meant. Could you check this?
          Hide
          Harish Butani added a comment -

          Ok, yes I see what you mean. I incorporated your findAlias changes. and created a new patch.
          I think the 'multiInsertBigTableCheck' check needs to be still done, because in case of multi insert we want the 'source' table to be the only big table choice. Do you agree?

          Show
          Harish Butani added a comment - Ok, yes I see what you mean. I incorporated your findAlias changes. and created a new patch. I think the 'multiInsertBigTableCheck' check needs to be still done, because in case of multi insert we want the 'source' table to be the only big table choice. Do you agree?
          Hide
          Hive QA added a comment -

          Overall: -1 at least one tests failed

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12628832/HIVE-6403.2.patch

          ERROR: -1 due to 22 failed/errored test(s), 5095 tests executed
          Failed tests:

          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join1
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join11
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join12
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join13
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join15
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join17
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join2
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join22
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join23
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join24
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join27
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join29
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join3
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join32
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join9
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_sortmerge_join_10
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join34
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join_reorder4
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_multiMapJoin2
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_multi_join_union
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union34
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vectorized_mapjoin
          

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1315/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1315/console

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          Tests exited with: TestsFailedException: 22 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12628832

          Show
          Hive QA added a comment - Overall : -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12628832/HIVE-6403.2.patch ERROR: -1 due to 22 failed/errored test(s), 5095 tests executed Failed tests: org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join1 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join11 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join12 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join13 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join15 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join17 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join2 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join22 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join23 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join24 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join27 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join29 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join3 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join32 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join9 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_sortmerge_join_10 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join34 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join_reorder4 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_multiMapJoin2 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_multi_join_union org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_union34 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vectorized_mapjoin Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1315/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1315/console Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 22 tests failed This message is automatically generated. ATTACHMENT ID: 12628832
          Hide
          Harish Butani added a comment -

          Resubmitting patch. Ran several of the tests locally, they succeed.
          The previous run was aborted.

          Show
          Harish Butani added a comment - Resubmitting patch. Ran several of the tests locally, they succeed. The previous run was aborted.
          Hide
          Navis added a comment -

          Harish Butani Took some time to understand multiInsertBigTableCheck() and now got it. But seeing auto_join17.q, I've realized that we missed handling map-side union cases. Updated in navis2.patch. Could you check that too?

          Show
          Navis added a comment - Harish Butani Took some time to understand multiInsertBigTableCheck() and now got it. But seeing auto_join17.q, I've realized that we missed handling map-side union cases. Updated in navis2.patch. Could you check that too?
          Hide
          Harish Butani added a comment -

          Navis i went through the patch; I think I understand the reason for the change. Couple of questions:

          • i don't see a union e.g. Can an e.g. be added that exercises the map-side union case.
          • i see several plans changed in .out files to scan src1 in place of src2. But the check at CommonJoinTaskDispatcher::cannotConvert line 447, should favor the right alias as the big table. So I don't understand why these plans are changed with your patch. For my understanding, can you please explain this change.

          Assigning the jira to you; you have made most of the changes, my contribution is very tiny; and I am just becoming familiar with the pieces you have touched in this patch.

          Show
          Harish Butani added a comment - Navis i went through the patch; I think I understand the reason for the change. Couple of questions: i don't see a union e.g. Can an e.g. be added that exercises the map-side union case. i see several plans changed in .out files to scan src1 in place of src2. But the check at CommonJoinTaskDispatcher::cannotConvert line 447, should favor the right alias as the big table. So I don't understand why these plans are changed with your patch. For my understanding, can you please explain this change. Assigning the jira to you; you have made most of the changes, my contribution is very tiny; and I am just becoming familiar with the pieces you have touched in this patch.
          Hide
          Navis added a comment -

          Harish Butani

          i don't see a union

          Ah, it's "auto_join27.q", "not auto_join17.q". Sorry for that.

          should favor the right alias as the big table

          Seemed a bug which was not fixed properly in HIVE-5945. I'll check that, too.

          my contribution is very tiny

          I would have never thought of multiInsertBigTableCheck() will be needed. Most of codes I've suggested are just easier part. I'll make this issue done. Thanks.

          Show
          Navis added a comment - Harish Butani i don't see a union Ah, it's "auto_join27.q", "not auto_join17.q". Sorry for that. should favor the right alias as the big table Seemed a bug which was not fixed properly in HIVE-5945 . I'll check that, too. my contribution is very tiny I would have never thought of multiInsertBigTableCheck() will be needed. Most of codes I've suggested are just easier part. I'll make this issue done. Thanks.
          Hide
          Navis added a comment -

          Add/fix comments and minor refactorings

          Show
          Navis added a comment - Add/fix comments and minor refactorings
          Hide
          Hive QA added a comment -

          Overall: -1 at least one tests failed

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12629301/HIVE-6403.4.patch.txt

          ERROR: -1 due to 21 failed/errored test(s), 5127 tests executed
          Failed tests:

          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join0
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join10
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join16
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join_without_localtask
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_sortmerge_join_9
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer4
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer6
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_mult_tables
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_mult_tables_compact
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_partitioned
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_update
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_bitmap
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_bitmap_auto_partitioned
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_bitmap_rc
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_compact
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_compact_2
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_infer_bucket_sort_convert_join
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join35
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_mapjoin_hook
          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_mapjoin_test_outer
          org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_parallel_orderby
          

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1356/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1356/console

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          Tests exited with: TestsFailedException: 21 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12629301

          Show
          Hive QA added a comment - Overall : -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12629301/HIVE-6403.4.patch.txt ERROR: -1 due to 21 failed/errored test(s), 5127 tests executed Failed tests: org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join0 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join10 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join16 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_join_without_localtask org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_auto_sortmerge_join_9 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer4 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_correlationoptimizer6 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_mult_tables org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_mult_tables_compact org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_partitioned org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_auto_update org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_bitmap org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_bitmap_auto_partitioned org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_bitmap_rc org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_compact org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_index_compact_2 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_infer_bucket_sort_convert_join org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_join35 org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_mapjoin_hook org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_mapjoin_test_outer org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_parallel_orderby Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1356/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1356/console Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 21 tests failed This message is automatically generated. ATTACHMENT ID: 12629301
          Hide
          Harish Butani added a comment -

          The patch looks good.
          I looked at the failures, most of them are assertion failures because of the join reorder fix you put in.
          There are a few failures to do with Alter Index Rebuild, like index_bitmap_rc.q.

          Show
          Harish Butani added a comment - The patch looks good. I looked at the failures, most of them are assertion failures because of the join reorder fix you put in. There are a few failures to do with Alter Index Rebuild, like index_bitmap_rc.q.
          Hide
          Navis added a comment -

          Hive index system seemed broken badly in somewhere.
          Even in trunk,

          hive> explain extended ALTER INDEX srcpart_index ON srcpart REBUILD;
          
          STAGE DEPENDENCIES:
            Stage-1 is a root stage
            Stage-0 depends on stages: Stage-1
            Stage-2 depends on stages: Stage-0
            null depends on stages: Stage-1
            Stage-3 depends on stages: Stage-1, Stage-1, Stage-1, Stage-1
            Stage-1 is a root stage
            Stage-0 depends on stages: Stage-1
            Stage-2 depends on stages: Stage-0
            null depends on stages: Stage-1
            Stage-1 is a root stage
            Stage-0 depends on stages: Stage-1
            Stage-2 depends on stages: Stage-0
            null depends on stages: Stage-1
            Stage-1 is a root stage
            Stage-0 depends on stages: Stage-1
            Stage-2 depends on stages: Stage-0
            null depends on stages: Stage-1
          

          I've never used index before but it seemed not a valid plan. I'll dig into this for a while.

          Show
          Navis added a comment - Hive index system seemed broken badly in somewhere. Even in trunk, hive> explain extended ALTER INDEX srcpart_index ON srcpart REBUILD; STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 Stage-2 depends on stages: Stage-0 null depends on stages: Stage-1 Stage-3 depends on stages: Stage-1, Stage-1, Stage-1, Stage-1 Stage-1 is a root stage Stage-0 depends on stages: Stage-1 Stage-2 depends on stages: Stage-0 null depends on stages: Stage-1 Stage-1 is a root stage Stage-0 depends on stages: Stage-1 Stage-2 depends on stages: Stage-0 null depends on stages: Stage-1 Stage-1 is a root stage Stage-0 depends on stages: Stage-1 Stage-2 depends on stages: Stage-0 null depends on stages: Stage-1 I've never used index before but it seemed not a valid plan. I'll dig into this for a while.
          Hide
          Navis added a comment -

          It was not that bad as it first looked. I've used task ID for equality of task but index builder resets ID (even not assigns ID for index metadata updator). Changed not to reset ID and seemed working good. I'll update the patch shortly after confirming that.

            Stage-1 is a root stage
            Stage-0 depends on stages: Stage-1
            Stage-2 depends on stages: Stage-0
            Stage-3 depends on stages: Stage-1
            Stage-16 depends on stages: Stage-1, Stage-5, Stage-9, Stage-13
            Stage-5 is a root stage
            Stage-4 depends on stages: Stage-5
            Stage-6 depends on stages: Stage-4
            Stage-7 depends on stages: Stage-5
            Stage-9 is a root stage
            Stage-8 depends on stages: Stage-9
            Stage-10 depends on stages: Stage-8
            Stage-11 depends on stages: Stage-9
            Stage-13 is a root stage
            Stage-12 depends on stages: Stage-13
            Stage-14 depends on stages: Stage-12
            Stage-15 depends on stages: Stage-13
          
          Show
          Navis added a comment - It was not that bad as it first looked. I've used task ID for equality of task but index builder resets ID (even not assigns ID for index metadata updator). Changed not to reset ID and seemed working good. I'll update the patch shortly after confirming that. Stage-1 is a root stage Stage-0 depends on stages: Stage-1 Stage-2 depends on stages: Stage-0 Stage-3 depends on stages: Stage-1 Stage-16 depends on stages: Stage-1, Stage-5, Stage-9, Stage-13 Stage-5 is a root stage Stage-4 depends on stages: Stage-5 Stage-6 depends on stages: Stage-4 Stage-7 depends on stages: Stage-5 Stage-9 is a root stage Stage-8 depends on stages: Stage-9 Stage-10 depends on stages: Stage-8 Stage-11 depends on stages: Stage-9 Stage-13 is a root stage Stage-12 depends on stages: Stage-13 Stage-14 depends on stages: Stage-12 Stage-15 depends on stages: Stage-13
          Hide
          Hive QA added a comment -

          Overall: -1 no tests executed

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12629459/HIVE-6403.5.patch.txt

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1378/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1378/console

          Messages:

          **** This message was trimmed, see log for full details ****
          Reverted 'ql/src/test/results/clientpositive/decimal_5.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucketmapjoin8.q.out'
          Reverted 'ql/src/test/results/clientpositive/progress_1.q.out'
          Reverted 'ql/src/test/results/clientpositive/nestedvirtual.q.out'
          Reverted 'ql/src/test/results/clientpositive/parallel.q.out'
          Reverted 'ql/src/test/results/clientpositive/convert_enum_to_string.q.out'
          Reverted 'ql/src/test/results/clientpositive/annotate_stats_filter.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucketmapjoin12.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby8_map_skew.q.out'
          Reverted 'ql/src/test/results/clientpositive/varchar_1.q.out'
          Reverted 'ql/src/test/results/clientpositive/insert1_overwrite_partitions.q.out'
          Reverted 'ql/src/test/results/clientpositive/join27.q.out'
          Reverted 'ql/src/test/results/clientpositive/load_file_with_space_in_the_name.q.out'
          Reverted 'ql/src/test/results/clientpositive/load_dyn_part11.q.out'
          Reverted 'ql/src/test/results/clientpositive/input4.q.out'
          Reverted 'ql/src/test/results/clientpositive/stats6.q.out'
          Reverted 'ql/src/test/results/clientpositive/leadlag_queries.q.out'
          Reverted 'ql/src/test/results/clientpositive/rename_partition_location.q.out'
          Reverted 'ql/src/test/results/clientpositive/udf_translate.q.out'
          Reverted 'ql/src/test/results/clientpositive/union12.q.out'
          Reverted 'ql/src/test/results/clientpositive/index_compact_2.q.out'
          Reverted 'ql/src/test/results/clientpositive/udf2.q.out'
          Reverted 'ql/src/test/results/clientpositive/sort_merge_join_desc_1.q.out'
          Reverted 'ql/src/test/results/clientpositive/windowing_udaf.q.out'
          Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_17.q.out'
          Reverted 'ql/src/test/results/clientpositive/ppd_repeated_alias.q.out'
          Reverted 'ql/src/test/results/clientpositive/join36.q.out'
          Reverted 'ql/src/test/results/clientpositive/avro_joins.q.out'
          Reverted 'ql/src/test/results/clientpositive/drop_with_concurrency.q.out'
          Reverted 'ql/src/test/results/clientpositive/lock2.q.out'
          Reverted 'ql/src/test/results/clientpositive/input_part5.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucketmapjoin3.q.out'
          Reverted 'ql/src/test/results/clientpositive/insert_into2.q.out'
          Reverted 'ql/src/test/results/clientpositive/alter_skewed_table.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out'
          Reverted 'ql/src/test/results/clientpositive/timestamp_1.q.out'
          Reverted 'ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby12.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby1_limit.q.out'
          Reverted 'ql/src/test/results/clientpositive/cast1.q.out'
          Reverted 'ql/src/test/results/clientpositive/input16_cc.q.out'
          Reverted 'ql/src/test/results/clientpositive/annotate_stats_part.q.out'
          Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat15.q.out'
          Reverted 'ql/src/test/results/clientpositive/stats1.q.out'
          Reverted 'ql/src/test/results/clientpositive/symlink_text_input_format.q.out'
          Reverted 'ql/src/test/results/clientpositive/ptf_register_tblfn.q.out'
          Reverted 'ql/src/test/results/clientpositive/ddltime.q.out'
          Reverted 'ql/src/test/results/clientpositive/uniquejoin.q.out'
          Reverted 'ql/src/test/results/clientpositive/ppd_constant_expr.q.out'
          Reverted 'ql/src/test/results/clientpositive/union30.q.out'
          Reverted 'ql/src/test/results/clientpositive/timestamp_null.q.out'
          Reverted 'ql/src/test/results/clientpositive/combine1.q.out'
          Reverted 'ql/src/test/results/clientpositive/avro_sanity_test.q.out'
          Reverted 'ql/src/test/results/clientpositive/exim_06_one_part.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby2_noskew.q.out'
          Reverted 'ql/src/test/results/clientpositive/index_stale.q.out'
          Reverted 'ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out'
          Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_12.q.out'
          Reverted 'ql/src/test/results/clientpositive/metadataonly1.q.out'
          Reverted 'ql/src/test/results/clientpositive/join31.q.out'
          Reverted 'ql/src/test/results/clientpositive/concatenate_inherit_table_location.q.out'
          Reverted 'ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out'
          Reverted 'ql/src/test/results/clientpositive/rcfile_toleratecorruptions.q.out'
          Reverted 'ql/src/test/results/clientpositive/auto_join7.q.out'
          Reverted 'ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out'
          Reverted 'ql/src/test/results/clientpositive/tablename_with_select.q.out'
          Reverted 'ql/src/test/results/clientpositive/exim_04_all_part.q.out'
          Reverted 'ql/src/test/results/clientpositive/join32_lessSize.q.out'
          Reverted 'ql/src/test/results/clientpositive/correlationoptimizer11.q.out'
          Reverted 'ql/src/test/results/clientpositive/multiMapJoin1.q.out'
          Reverted 'ql/src/test/results/clientpositive/alter3.q.out'
          Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_21.q.out'
          Reverted 'ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby4_map_skew.q.out'
          Reverted 'ql/src/test/results/clientpositive/exim_01_nonpart.q.out'
          Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby7_noskew.q.out'
          Reverted 'ql/src/test/results/clientpositive/test_boolean_whereclause.q.out'
          Reverted 'ql/src/test/results/clientpositive/drop_index_removes_partition_dirs.q.out'
          Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat10.q.out'
          Reverted 'ql/src/test/results/clientpositive/compute_stats_long.q.out'
          Reverted 'ql/src/test/results/clientpositive/inputddl7.q.out'
          Reverted 'ql/src/test/results/clientpositive/join5.q.out'
          Reverted 'ql/src/test/results/clientpositive/describe_syntax.q.out'
          Reverted 'ql/src/test/results/clientpositive/add_part_multiple.q.out'
          Reverted 'ql/src/test/results/clientpositive/external_table_with_space_in_location_path.q.out'
          Reverted 'ql/src/test/results/clientpositive/fileformat_text.q.out'
          Reverted 'ql/src/test/results/clientpositive/char_udf1.q.out'
          Reverted 'ql/src/test/results/clientpositive/date_1.q.out'
          Reverted 'ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out'
          Reverted 'ql/src/test/results/clientpositive/list_bucket_dml_10.q.out'
          Reverted 'ql/src/test/results/clientpositive/windowing.q.out'
          Reverted 'ql/src/test/results/clientpositive/auto_join2.q.out'
          Reverted 'ql/src/test/results/clientpositive/udf_reverse.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out'
          Reverted 'ql/src/test/results/clientpositive/union3.q.out'
          Reverted 'ql/src/test/results/clientpositive/show_create_table_partitioned.q.out'
          Reverted 'ql/src/test/results/clientpositive/input1_limit.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby8.q.out'
          Reverted 'ql/src/test/results/clientpositive/scriptfile1.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby_sort_9.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby_grouping_id1.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out'
          Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out'
          Reverted 'ql/src/test/results/clientpositive/alter_varchar2.q.out'
          Reverted 'ql/src/test/results/clientpositive/skewjoinopt6.q.out'
          Reverted 'ql/src/test/results/clientpositive/load_dyn_part6.q.out'
          Reverted 'ql/src/test/results/clientpositive/inputddl2.q.out'
          Reverted 'ql/src/test/results/clientpositive/drop_partitions_filter2.q.out'
          Reverted 'ql/src/test/results/clientpositive/sample7.q.out'
          Reverted 'ql/src/test/results/clientpositive/rcfile_union.q.out'
          Reverted 'ql/src/test/results/clientpositive/nullinput2.q.out'
          Reverted 'ql/src/test/results/clientpositive/exim_10_external_managed.q.out'
          Reverted 'ql/src/test/results/clientpositive/ptf_general_queries.q.out'
          Reverted 'ql/src/test/results/clientpositive/create_escape.q.out'
          Reverted 'ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out'
          Reverted 'ql/src/test/results/clientpositive/annotate_stats_limit.q.out'
          Reverted 'ql/src/test/results/clientpositive/alter_char2.q.out'
          Reverted 'ql/src/test/results/clientpositive/input_testsequencefile.q.out'
          Reverted 'ql/src/test/results/clientpositive/join_view.q.out'
          Reverted 'ql/src/test/results/clientpositive/udf_get_json_object.q.out'
          Reverted 'ql/src/test/results/clientpositive/input_testxpath.q.out'
          Reverted 'ql/src/test/results/clientpositive/input19.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucket_map_join_2.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby3.q.out'
          Reverted 'ql/src/test/results/clientpositive/ba_table3.q.out'
          Reverted 'ql/src/test/results/clientpositive/join_empty.q.out'
          Reverted 'ql/src/test/results/clientpositive/windowing_rank.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby_sort_4.q.out'
          Reverted 'ql/src/test/results/clientpositive/parquet_partitioned.q.out'
          Reverted 'ql/src/test/results/clientpositive/reduce_deduplicate_exclude_gby.q.out'
          Reverted 'ql/src/test/results/clientpositive/skewjoinopt18.q.out'
          Reverted 'ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out'
          Reverted 'ql/src/test/results/clientpositive/skewjoinopt1.q.out'
          Reverted 'ql/src/test/results/clientpositive/load_dyn_part1.q.out'
          Reverted 'ql/src/test/results/clientpositive/sample2.q.out'
          Reverted 'ql/src/test/results/clientpositive/exim_03_nonpart_over_compat.q.out'
          Reverted 'ql/src/test/results/clientpositive/stats16.q.out'
          Reverted 'ql/src/test/results/clientpositive/input28.q.out'
          Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_4.q.out'
          Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out'
          Reverted 'ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out'
          Reverted 'ql/src/test/results/clientpositive/ppd_union_view.q.out'
          Reverted 'ql/src/test/results/clientpositive/input_testxpath2.q.out'
          Reverted 'ql/src/test/results/clientpositive/create_like_tbl_props.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out'
          Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat9.q.out'
          Reverted 'ql/src/test/results/clientpositive/truncate_column.q.out'
          Reverted 'ql/src/test/results/clientpositive/mergejoins.q.out'
          Reverted 'ql/src/test/results/clientpositive/groupby_complex_types.q.out'
          Reverted 'ql/src/test/results/clientpositive/input14.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucketcontext_5.q.out'
          Reverted 'ql/src/test/results/clientpositive/input37.q.out'
          Reverted 'ql/src/test/results/clientpositive/binary_table_colserde.q.out'
          Reverted 'ql/src/test/results/clientpositive/skewjoinopt13.q.out'
          Reverted 'ql/src/test/results/clientpositive/describe_comment_nonascii.q.out'
          Reverted 'ql/src/test/results/clientpositive/mapreduce4.q.out'
          Reverted 'ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out'
          Reverted 'ql/src/test/results/clientpositive/nullscript.q.out'
          Reverted 'ql/src/test/results/clientpositive/stats11.q.out'
          Reverted 'ql/src/test/results/clientpositive/bucket5.q.out'
          Reverted 'ql/src/test/results/clientpositive/alter_merge_stats.q.out'
          Reverted 'ql/src/test/results/clientpositive/udf_round_2.q.out'
          Reverted 'ql/src/test/results/clientpositive/filter_numeric.q.out'
          Reverted 'ql/src/test/results/clientpositive/input46.q.out'
          Reverted 'ql/src/test/queries/clientnegative/authorization_addpartition.q'
          Reverted 'ql/src/test/queries/clientnegative/authorization_droppartition.q'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/LoadSemanticAnalyzer.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/hooks/ReadEntity.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/hooks/WriteEntity.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/SQLAuthorizationUtils.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/Operation2Privilege.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/RequiredPrivileges.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/SQLStdHiveAuthorizationValidator.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/SessionStateConfigUserAuthenticator.java'
          Reverted 'ql/src/java/org/apache/hadoop/hive/ql/Driver.java'
          ++ awk '{print $2}'
          ++ egrep -v '^X|^Performing status on external'
          ++ svn status --no-ignore
          + rm -rf target datanucleus.log ant/target shims/target shims/0.20/target shims/0.20S/target shims/0.23/target shims/aggregator/target shims/common/target shims/common-secure/target packaging/target hbase-handler/target testutils/target jdbc/target metastore/target itests/target itests/hcatalog-unit/target itests/test-serde/target itests/qtest/target itests/hive-unit/target itests/custom-serde/target itests/util/target hcatalog/target hcatalog/storage-handlers/hbase/target hcatalog/server-extensions/target hcatalog/core/target hcatalog/webhcat/svr/target hcatalog/webhcat/java-client/target hcatalog/hcatalog-pig-adapter/target hwi/target common/target common/src/gen service/target contrib/target serde/target beeline/target odbc/target cli/target ql/dependency-reduced-pom.xml ql/target ql/src/test/results/clientnegative/authorization_uri_create_table_ext.q.out ql/src/test/results/clientnegative/authorization_uri_insert.q.out ql/src/test/results/clientnegative/authorization_uri_load_data.q.out ql/src/test/results/clientnegative/authorization_uri_insert_local.q.out ql/src/test/results/clientnegative/authorization_uri_create_table1.q.out ql/src/test/results/clientnegative/authorization_uri_altertab_setloc.q.out ql/src/test/results/clientnegative/authorization_uri_createdb.q.out ql/src/test/results/clientnegative/authorization_uri_index.q.out ql/src/test/results/clientnegative/authorization_uri_add_partition.q.out ql/src/test/results/clientnegative/authorization_uri_alterpart_loc.q.out ql/src/test/queries/clientnegative/authorization_uri_load_data.q ql/src/test/queries/clientnegative/authorization_uri_createdb.q ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q ql/src/test/queries/clientnegative/authorization_uri_insert_local.q ql/src/test/queries/clientnegative/authorization_uri_add_partition.q ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q ql/src/test/queries/clientnegative/authorization_uri_insert.q ql/src/test/queries/clientnegative/authorization_uri_index.q ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q ql/src/test/queries/clientnegative/authorization_uri_create_table1.q ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java.orig ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/Operation2Privilege.java.orig
          + svn update
          
          Fetching external item into 'hcatalog/src/test/e2e/harness'
          External at revision 1569331.
          
          At revision 1569331.
          + patchCommandPath=/data/hive-ptest/working/scratch/smart-apply-patch.sh
          + patchFilePath=/data/hive-ptest/working/scratch/build.patch
          + [[ -f /data/hive-ptest/working/scratch/build.patch ]]
          + chmod +x /data/hive-ptest/working/scratch/smart-apply-patch.sh
          + /data/hive-ptest/working/scratch/smart-apply-patch.sh /data/hive-ptest/working/scratch/build.patch
          The patch does not appear to apply with p0, p1, or p2
          + exit 1
          '
          

          This message is automatically generated.

          ATTACHMENT ID: 12629459

          Show
          Hive QA added a comment - Overall : -1 no tests executed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12629459/HIVE-6403.5.patch.txt Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1378/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1378/console Messages: **** This message was trimmed, see log for full details **** Reverted 'ql/src/test/results/clientpositive/decimal_5.q.out' Reverted 'ql/src/test/results/clientpositive/bucketmapjoin8.q.out' Reverted 'ql/src/test/results/clientpositive/progress_1.q.out' Reverted 'ql/src/test/results/clientpositive/nestedvirtual.q.out' Reverted 'ql/src/test/results/clientpositive/parallel.q.out' Reverted 'ql/src/test/results/clientpositive/convert_enum_to_string.q.out' Reverted 'ql/src/test/results/clientpositive/annotate_stats_filter.q.out' Reverted 'ql/src/test/results/clientpositive/bucketmapjoin12.q.out' Reverted 'ql/src/test/results/clientpositive/groupby8_map_skew.q.out' Reverted 'ql/src/test/results/clientpositive/varchar_1.q.out' Reverted 'ql/src/test/results/clientpositive/insert1_overwrite_partitions.q.out' Reverted 'ql/src/test/results/clientpositive/join27.q.out' Reverted 'ql/src/test/results/clientpositive/load_file_with_space_in_the_name.q.out' Reverted 'ql/src/test/results/clientpositive/load_dyn_part11.q.out' Reverted 'ql/src/test/results/clientpositive/input4.q.out' Reverted 'ql/src/test/results/clientpositive/stats6.q.out' Reverted 'ql/src/test/results/clientpositive/leadlag_queries.q.out' Reverted 'ql/src/test/results/clientpositive/rename_partition_location.q.out' Reverted 'ql/src/test/results/clientpositive/udf_translate.q.out' Reverted 'ql/src/test/results/clientpositive/union12.q.out' Reverted 'ql/src/test/results/clientpositive/index_compact_2.q.out' Reverted 'ql/src/test/results/clientpositive/udf2.q.out' Reverted 'ql/src/test/results/clientpositive/sort_merge_join_desc_1.q.out' Reverted 'ql/src/test/results/clientpositive/windowing_udaf.q.out' Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_17.q.out' Reverted 'ql/src/test/results/clientpositive/ppd_repeated_alias.q.out' Reverted 'ql/src/test/results/clientpositive/join36.q.out' Reverted 'ql/src/test/results/clientpositive/avro_joins.q.out' Reverted 'ql/src/test/results/clientpositive/drop_with_concurrency.q.out' Reverted 'ql/src/test/results/clientpositive/lock2.q.out' Reverted 'ql/src/test/results/clientpositive/input_part5.q.out' Reverted 'ql/src/test/results/clientpositive/bucketmapjoin3.q.out' Reverted 'ql/src/test/results/clientpositive/insert_into2.q.out' Reverted 'ql/src/test/results/clientpositive/alter_skewed_table.q.out' Reverted 'ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out' Reverted 'ql/src/test/results/clientpositive/timestamp_1.q.out' Reverted 'ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out' Reverted 'ql/src/test/results/clientpositive/groupby12.q.out' Reverted 'ql/src/test/results/clientpositive/groupby1_limit.q.out' Reverted 'ql/src/test/results/clientpositive/cast1.q.out' Reverted 'ql/src/test/results/clientpositive/input16_cc.q.out' Reverted 'ql/src/test/results/clientpositive/annotate_stats_part.q.out' Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat15.q.out' Reverted 'ql/src/test/results/clientpositive/stats1.q.out' Reverted 'ql/src/test/results/clientpositive/symlink_text_input_format.q.out' Reverted 'ql/src/test/results/clientpositive/ptf_register_tblfn.q.out' Reverted 'ql/src/test/results/clientpositive/ddltime.q.out' Reverted 'ql/src/test/results/clientpositive/uniquejoin.q.out' Reverted 'ql/src/test/results/clientpositive/ppd_constant_expr.q.out' Reverted 'ql/src/test/results/clientpositive/union30.q.out' Reverted 'ql/src/test/results/clientpositive/timestamp_null.q.out' Reverted 'ql/src/test/results/clientpositive/combine1.q.out' Reverted 'ql/src/test/results/clientpositive/avro_sanity_test.q.out' Reverted 'ql/src/test/results/clientpositive/exim_06_one_part.q.out' Reverted 'ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out' Reverted 'ql/src/test/results/clientpositive/groupby2_noskew.q.out' Reverted 'ql/src/test/results/clientpositive/index_stale.q.out' Reverted 'ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out' Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_12.q.out' Reverted 'ql/src/test/results/clientpositive/metadataonly1.q.out' Reverted 'ql/src/test/results/clientpositive/join31.q.out' Reverted 'ql/src/test/results/clientpositive/concatenate_inherit_table_location.q.out' Reverted 'ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out' Reverted 'ql/src/test/results/clientpositive/rcfile_toleratecorruptions.q.out' Reverted 'ql/src/test/results/clientpositive/auto_join7.q.out' Reverted 'ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out' Reverted 'ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out' Reverted 'ql/src/test/results/clientpositive/tablename_with_select.q.out' Reverted 'ql/src/test/results/clientpositive/exim_04_all_part.q.out' Reverted 'ql/src/test/results/clientpositive/join32_lessSize.q.out' Reverted 'ql/src/test/results/clientpositive/correlationoptimizer11.q.out' Reverted 'ql/src/test/results/clientpositive/multiMapJoin1.q.out' Reverted 'ql/src/test/results/clientpositive/alter3.q.out' Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_21.q.out' Reverted 'ql/src/test/results/clientpositive/exim_23_import_part_authsuccess.q.out' Reverted 'ql/src/test/results/clientpositive/groupby4_map_skew.q.out' Reverted 'ql/src/test/results/clientpositive/exim_01_nonpart.q.out' Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out' Reverted 'ql/src/test/results/clientpositive/groupby7_noskew.q.out' Reverted 'ql/src/test/results/clientpositive/test_boolean_whereclause.q.out' Reverted 'ql/src/test/results/clientpositive/drop_index_removes_partition_dirs.q.out' Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat10.q.out' Reverted 'ql/src/test/results/clientpositive/compute_stats_long.q.out' Reverted 'ql/src/test/results/clientpositive/inputddl7.q.out' Reverted 'ql/src/test/results/clientpositive/join5.q.out' Reverted 'ql/src/test/results/clientpositive/describe_syntax.q.out' Reverted 'ql/src/test/results/clientpositive/add_part_multiple.q.out' Reverted 'ql/src/test/results/clientpositive/external_table_with_space_in_location_path.q.out' Reverted 'ql/src/test/results/clientpositive/fileformat_text.q.out' Reverted 'ql/src/test/results/clientpositive/char_udf1.q.out' Reverted 'ql/src/test/results/clientpositive/date_1.q.out' Reverted 'ql/src/test/results/clientpositive/exim_08_nonpart_rename.q.out' Reverted 'ql/src/test/results/clientpositive/list_bucket_dml_10.q.out' Reverted 'ql/src/test/results/clientpositive/windowing.q.out' Reverted 'ql/src/test/results/clientpositive/auto_join2.q.out' Reverted 'ql/src/test/results/clientpositive/udf_reverse.q.out' Reverted 'ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out' Reverted 'ql/src/test/results/clientpositive/union3.q.out' Reverted 'ql/src/test/results/clientpositive/show_create_table_partitioned.q.out' Reverted 'ql/src/test/results/clientpositive/input1_limit.q.out' Reverted 'ql/src/test/results/clientpositive/groupby8.q.out' Reverted 'ql/src/test/results/clientpositive/scriptfile1.q.out' Reverted 'ql/src/test/results/clientpositive/groupby_sort_9.q.out' Reverted 'ql/src/test/results/clientpositive/groupby_grouping_id1.q.out' Reverted 'ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out' Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out' Reverted 'ql/src/test/results/clientpositive/alter_varchar2.q.out' Reverted 'ql/src/test/results/clientpositive/skewjoinopt6.q.out' Reverted 'ql/src/test/results/clientpositive/load_dyn_part6.q.out' Reverted 'ql/src/test/results/clientpositive/inputddl2.q.out' Reverted 'ql/src/test/results/clientpositive/drop_partitions_filter2.q.out' Reverted 'ql/src/test/results/clientpositive/sample7.q.out' Reverted 'ql/src/test/results/clientpositive/rcfile_union.q.out' Reverted 'ql/src/test/results/clientpositive/nullinput2.q.out' Reverted 'ql/src/test/results/clientpositive/exim_10_external_managed.q.out' Reverted 'ql/src/test/results/clientpositive/ptf_general_queries.q.out' Reverted 'ql/src/test/results/clientpositive/create_escape.q.out' Reverted 'ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out' Reverted 'ql/src/test/results/clientpositive/annotate_stats_limit.q.out' Reverted 'ql/src/test/results/clientpositive/alter_char2.q.out' Reverted 'ql/src/test/results/clientpositive/input_testsequencefile.q.out' Reverted 'ql/src/test/results/clientpositive/join_view.q.out' Reverted 'ql/src/test/results/clientpositive/udf_get_json_object.q.out' Reverted 'ql/src/test/results/clientpositive/input_testxpath.q.out' Reverted 'ql/src/test/results/clientpositive/input19.q.out' Reverted 'ql/src/test/results/clientpositive/bucket_map_join_2.q.out' Reverted 'ql/src/test/results/clientpositive/groupby3.q.out' Reverted 'ql/src/test/results/clientpositive/ba_table3.q.out' Reverted 'ql/src/test/results/clientpositive/join_empty.q.out' Reverted 'ql/src/test/results/clientpositive/windowing_rank.q.out' Reverted 'ql/src/test/results/clientpositive/groupby_sort_4.q.out' Reverted 'ql/src/test/results/clientpositive/parquet_partitioned.q.out' Reverted 'ql/src/test/results/clientpositive/reduce_deduplicate_exclude_gby.q.out' Reverted 'ql/src/test/results/clientpositive/skewjoinopt18.q.out' Reverted 'ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out' Reverted 'ql/src/test/results/clientpositive/skewjoinopt1.q.out' Reverted 'ql/src/test/results/clientpositive/load_dyn_part1.q.out' Reverted 'ql/src/test/results/clientpositive/sample2.q.out' Reverted 'ql/src/test/results/clientpositive/exim_03_nonpart_over_compat.q.out' Reverted 'ql/src/test/results/clientpositive/stats16.q.out' Reverted 'ql/src/test/results/clientpositive/input28.q.out' Reverted 'ql/src/test/results/clientpositive/smb_mapjoin_4.q.out' Reverted 'ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out' Reverted 'ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out' Reverted 'ql/src/test/results/clientpositive/ppd_union_view.q.out' Reverted 'ql/src/test/results/clientpositive/input_testxpath2.q.out' Reverted 'ql/src/test/results/clientpositive/create_like_tbl_props.q.out' Reverted 'ql/src/test/results/clientpositive/groupby7_map_multi_single_reducer.q.out' Reverted 'ql/src/test/results/clientpositive/partition_wise_fileformat9.q.out' Reverted 'ql/src/test/results/clientpositive/truncate_column.q.out' Reverted 'ql/src/test/results/clientpositive/mergejoins.q.out' Reverted 'ql/src/test/results/clientpositive/groupby_complex_types.q.out' Reverted 'ql/src/test/results/clientpositive/input14.q.out' Reverted 'ql/src/test/results/clientpositive/bucketcontext_5.q.out' Reverted 'ql/src/test/results/clientpositive/input37.q.out' Reverted 'ql/src/test/results/clientpositive/binary_table_colserde.q.out' Reverted 'ql/src/test/results/clientpositive/skewjoinopt13.q.out' Reverted 'ql/src/test/results/clientpositive/describe_comment_nonascii.q.out' Reverted 'ql/src/test/results/clientpositive/mapreduce4.q.out' Reverted 'ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out' Reverted 'ql/src/test/results/clientpositive/nullscript.q.out' Reverted 'ql/src/test/results/clientpositive/stats11.q.out' Reverted 'ql/src/test/results/clientpositive/bucket5.q.out' Reverted 'ql/src/test/results/clientpositive/alter_merge_stats.q.out' Reverted 'ql/src/test/results/clientpositive/udf_round_2.q.out' Reverted 'ql/src/test/results/clientpositive/filter_numeric.q.out' Reverted 'ql/src/test/results/clientpositive/input46.q.out' Reverted 'ql/src/test/queries/clientnegative/authorization_addpartition.q' Reverted 'ql/src/test/queries/clientnegative/authorization_droppartition.q' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/LoadSemanticAnalyzer.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/hooks/ReadEntity.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/hooks/WriteEntity.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/SQLAuthorizationUtils.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/Operation2Privilege.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/RequiredPrivileges.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/SQLStdHiveAuthorizationValidator.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/security/SessionStateConfigUserAuthenticator.java' Reverted 'ql/src/java/org/apache/hadoop/hive/ql/Driver.java' ++ awk '{print $2}' ++ egrep -v '^X|^Performing status on external' ++ svn status --no-ignore + rm -rf target datanucleus.log ant/target shims/target shims/0.20/target shims/0.20S/target shims/0.23/target shims/aggregator/target shims/common/target shims/common-secure/target packaging/target hbase-handler/target testutils/target jdbc/target metastore/target itests/target itests/hcatalog-unit/target itests/test-serde/target itests/qtest/target itests/hive-unit/target itests/custom-serde/target itests/util/target hcatalog/target hcatalog/storage-handlers/hbase/target hcatalog/server-extensions/target hcatalog/core/target hcatalog/webhcat/svr/target hcatalog/webhcat/java-client/target hcatalog/hcatalog-pig-adapter/target hwi/target common/target common/src/gen service/target contrib/target serde/target beeline/target odbc/target cli/target ql/dependency-reduced-pom.xml ql/target ql/src/test/results/clientnegative/authorization_uri_create_table_ext.q.out ql/src/test/results/clientnegative/authorization_uri_insert.q.out ql/src/test/results/clientnegative/authorization_uri_load_data.q.out ql/src/test/results/clientnegative/authorization_uri_insert_local.q.out ql/src/test/results/clientnegative/authorization_uri_create_table1.q.out ql/src/test/results/clientnegative/authorization_uri_altertab_setloc.q.out ql/src/test/results/clientnegative/authorization_uri_createdb.q.out ql/src/test/results/clientnegative/authorization_uri_index.q.out ql/src/test/results/clientnegative/authorization_uri_add_partition.q.out ql/src/test/results/clientnegative/authorization_uri_alterpart_loc.q.out ql/src/test/queries/clientnegative/authorization_uri_load_data.q ql/src/test/queries/clientnegative/authorization_uri_createdb.q ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q ql/src/test/queries/clientnegative/authorization_uri_insert_local.q ql/src/test/queries/clientnegative/authorization_uri_add_partition.q ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q ql/src/test/queries/clientnegative/authorization_uri_insert.q ql/src/test/queries/clientnegative/authorization_uri_index.q ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q ql/src/test/queries/clientnegative/authorization_uri_create_table1.q ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java.orig ql/src/java/org/apache/hadoop/hive/ql/security/authorization/plugin/sqlstd/Operation2Privilege.java.orig + svn update Fetching external item into 'hcatalog/src/test/e2e/harness' External at revision 1569331. At revision 1569331. + patchCommandPath=/data/hive-ptest/working/scratch/smart-apply-patch.sh + patchFilePath=/data/hive-ptest/working/scratch/build.patch + [[ -f /data/hive-ptest/working/scratch/build.patch ]] + chmod +x /data/hive-ptest/working/scratch/smart-apply-patch.sh + /data/hive-ptest/working/scratch/smart-apply-patch.sh /data/hive-ptest/working/scratch/build.patch The patch does not appear to apply with p0, p1, or p2 + exit 1 ' This message is automatically generated. ATTACHMENT ID: 12629459
          Hide
          Harish Butani added a comment -

          +1
          will checkin once tests pass.

          Show
          Harish Butani added a comment - +1 will checkin once tests pass.
          Hide
          Navis added a comment -

          HIVE-6037 is reverted. I've kicked test.

          Show
          Navis added a comment - HIVE-6037 is reverted. I've kicked test.
          Hide
          Navis added a comment -

          Kick test

          Show
          Navis added a comment - Kick test
          Hide
          Hive QA added a comment -

          Overall: +1 all checks pass

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12633001/HIVE-6403.6.patch.txt

          SUCCESS: +1 5373 tests passed

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1655/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1655/console

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          

          This message is automatically generated.

          ATTACHMENT ID: 12633001

          Show
          Hive QA added a comment - Overall : +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12633001/HIVE-6403.6.patch.txt SUCCESS: +1 5373 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1655/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/1655/console Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase This message is automatically generated. ATTACHMENT ID: 12633001

            People

            • Assignee:
              Navis
              Reporter:
              Navis
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development