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

Query may generate different results depending on the number of reducers

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.14.0
    • Fix Version/s: 1.0.0
    • Component/s: Logical Optimizer
    • Labels:
      None

      Description

      Some queries may generate different results depending on the number of reducers, for example, tests like ppd_multi_insert.q, join_nullsafe.q, subquery_in.q, etc.

      Take subquery_in.q as example, if we add

      set mapred.reduce.tasks=3;
      

      to this test file, the result will be different (and wrong):

      @@ -903,5 +903,3 @@ where li.l_linenumber = 1 and
       POSTHOOK: type: QUERY
       POSTHOOK: Input: default@lineitem
       #### A masked pattern was here ####
      -108570 8571
      -4297   1798
      
      1. HIVE-9112-0.14.1-branch.patch
        37 kB
        Ashutosh Chauhan
      2. HIVE-9112.2.patch
        68 kB
        Chao Sun
      3. HIVE-9112.1.patch
        47 kB
        Ted Xu
      4. HIVE-9112.patch
        33 kB
        Ted Xu

        Issue Links

          Activity

          Hide
          xuefuz Xuefu Zhang added a comment -

          Ashutosh Chauhan and Harish Butani, do you have any idea why this is happening? Thanks.

          Show
          xuefuz Xuefu Zhang added a comment - Ashutosh Chauhan and Harish Butani , do you have any idea why this is happening? Thanks.
          Hide
          ashutoshc Ashutosh Chauhan added a comment -

          Out of three queries cited in description, atleast 1 one of those join_nullsafe.q was impacted in fix of HIVE-9025 and should have been fixed after that. Chao Sun Did you run these tests with fix of HIVE-9025 applied?

          Other than that, OTOH I don't have a theory what might be wrong here.

          Show
          ashutoshc Ashutosh Chauhan added a comment - Out of three queries cited in description, atleast 1 one of those join_nullsafe.q was impacted in fix of HIVE-9025 and should have been fixed after that. Chao Sun Did you run these tests with fix of HIVE-9025 applied? Other than that, OTOH I don't have a theory what might be wrong here.
          Hide
          csun Chao Sun added a comment -

          Ashutosh Chauhan Yes, I ran them with the HIVE-9025 patch. To me, they appear to be a different issue - when I debugged into it, the hash code issue in HIVE-9025 is gone.

          Show
          csun Chao Sun added a comment - Ashutosh Chauhan Yes, I ran them with the HIVE-9025 patch. To me, they appear to be a different issue - when I debugged into it, the hash code issue in HIVE-9025 is gone.
          Hide
          xuefuz Xuefu Zhang added a comment -

          Ashutosh Chauhan, any further idea on this? Thanks.

          Show
          xuefuz Xuefu Zhang added a comment - Ashutosh Chauhan , any further idea on this? Thanks.
          Hide
          ashutoshc Ashutosh Chauhan added a comment -

          Not really. Probably need to do git bisect to figure out which commit brought in this bug.

          Show
          ashutoshc Ashutosh Chauhan added a comment - Not really. Probably need to do git bisect to figure out which commit brought in this bug.
          Hide
          csun Chao Sun added a comment -

          Hi Ted Xu, looks like this is related to Constant Propagation. The (partial) plan with this optimization:

            ...
           78   Stage: Stage-3
           79     Map Reduce
           80       Map Operator Tree:
           81           TableScan
           82             Reduce Output Operator
           83               key expressions: _col1 (type: int), 1 (type: int)
           84               sort order: ++
           85               Map-reduce partition columns: _col1 (type: int)
           86               Statistics: Num rows: 27 Data size: 3298 Basic stats: COMPLETE Column stats: NONE
           87               value expressions: _col0 (type: int), _col3 (type: int)
           88           TableScan
           89             alias: lineitem
           90             Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE
           91             Filter Operator
           92               predicate: ((((l_shipmode = 'AIR') and l_orderkey is not null) and l_linenumber is not null) and (l_linenumber = 1)) (type: boolean)
           93               Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
           94               Select Operator
           95                 expressions: l_orderkey (type: int), 1 (type: int)
           96                 outputColumnNames: _col0, _col1
           97                 Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
           98                 Group By Operator
           99                   keys: _col0 (type: int), _col1 (type: int)
          100                   mode: hash
          101                   outputColumnNames: _col0, _col1
          102                   Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
          103                   Reduce Output Operator
          104                     key expressions: _col0 (type: int), _col1 (type: int)
          105                     sort order: ++
          106                     Map-reduce partition columns: _col0 (type: int), _col1 (type: int)
          107                     Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE
          108       Reduce Operator Tree:
          109         Join Operator
          110           condition map:
          111                Left Semi Join 0 to 1
          112           keys:
          113             0 _col1 (type: int), _col4 (type: int)
          114             1 _col0 (type: int), _col1 (type: int)
          115           outputColumnNames: _col0, _col3
          116           Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
          117           Select Operator
          118             expressions: _col0 (type: int), _col3 (type: int)
          119             outputColumnNames: _col0, _col1
          120             Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
          121             File Output Operator
          122               compressed: false
          123               Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE
          124               table:
          125                   input format: org.apache.hadoop.mapred.TextInputFormat
          126                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
          127                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
          ...
          

          And diff for this part (on the left is the plan w/o the optimization):

          83c83
          <               key expressions: _col1 (type: int), _col4 (type: int)
          ---
          >               key expressions: _col1 (type: int), 1 (type: int)
          85c85
          <               Map-reduce partition columns: _col1 (type: int), _col4 (type: int)
          ---
          >               Map-reduce partition columns: _col1 (type: int)
          95c95
          <                 expressions: l_orderkey (type: int), l_linenumber (type: int)
          ---
          >                 expressions: l_orderkey (type: int), 1 (type: int)
          

          Notice that on line 85, the MR partition column _col4 has been optimized away, which causes an inconsistency.
          Later on, output rows for join will be hashed to different reducers, and therefore introduces wrong results.

          I saw that Navis has a comment about some similar issue, maybe it's related?

          I'm not an expert in Constant Propagation, and I'm thinking whether you can take a look at this issue? Thanks.

          Show
          csun Chao Sun added a comment - Hi Ted Xu , looks like this is related to Constant Propagation. The (partial) plan with this optimization: ... 78 Stage: Stage-3 79 Map Reduce 80 Map Operator Tree: 81 TableScan 82 Reduce Output Operator 83 key expressions: _col1 (type: int), 1 (type: int) 84 sort order: ++ 85 Map-reduce partition columns: _col1 (type: int) 86 Statistics: Num rows: 27 Data size: 3298 Basic stats: COMPLETE Column stats: NONE 87 value expressions: _col0 (type: int), _col3 (type: int) 88 TableScan 89 alias: lineitem 90 Statistics: Num rows: 100 Data size: 11999 Basic stats: COMPLETE Column stats: NONE 91 Filter Operator 92 predicate: ((((l_shipmode = 'AIR') and l_orderkey is not null) and l_linenumber is not null) and (l_linenumber = 1)) (type: boolean) 93 Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE 94 Select Operator 95 expressions: l_orderkey (type: int), 1 (type: int) 96 outputColumnNames: _col0, _col1 97 Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE 98 Group By Operator 99 keys: _col0 (type: int), _col1 (type: int) 100 mode: hash 101 outputColumnNames: _col0, _col1 102 Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE 103 Reduce Output Operator 104 key expressions: _col0 (type: int), _col1 (type: int) 105 sort order: ++ 106 Map-reduce partition columns: _col0 (type: int), _col1 (type: int) 107 Statistics: Num rows: 6 Data size: 719 Basic stats: COMPLETE Column stats: NONE 108 Reduce Operator Tree: 109 Join Operator 110 condition map: 111 Left Semi Join 0 to 1 112 keys: 113 0 _col1 (type: int), _col4 (type: int) 114 1 _col0 (type: int), _col1 (type: int) 115 outputColumnNames: _col0, _col3 116 Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE 117 Select Operator 118 expressions: _col0 (type: int), _col3 (type: int) 119 outputColumnNames: _col0, _col1 120 Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE 121 File Output Operator 122 compressed: false 123 Statistics: Num rows: 29 Data size: 3627 Basic stats: COMPLETE Column stats: NONE 124 table: 125 input format: org.apache.hadoop.mapred.TextInputFormat 126 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat 127 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe ... And diff for this part (on the left is the plan w/o the optimization): 83c83 < key expressions: _col1 (type: int), _col4 (type: int) --- > key expressions: _col1 (type: int), 1 (type: int) 85c85 < Map-reduce partition columns: _col1 (type: int), _col4 (type: int) --- > Map-reduce partition columns: _col1 (type: int) 95c95 < expressions: l_orderkey (type: int), l_linenumber (type: int) --- > expressions: l_orderkey (type: int), 1 (type: int) Notice that on line 85, the MR partition column _col4 has been optimized away, which causes an inconsistency. Later on, output rows for join will be hashed to different reducers, and therefore introduces wrong results. I saw that Navis has a comment about some similar issue, maybe it's related? I'm not an expert in Constant Propagation, and I'm thinking whether you can take a look at this issue? Thanks.
          Hide
          csun Chao Sun added a comment -

          Forgot to mention, the plan from last comment is for the last query in subquery_in:

          -- non agg, corr, with join in Parent Query
          select p.p_partkey, li.l_suppkey
          from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
          where li.l_linenumber = 1 and
           li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber)
          ;
          
          Show
          csun Chao Sun added a comment - Forgot to mention, the plan from last comment is for the last query in subquery_in : -- non agg, corr, with join in Parent Query select p.p_partkey, li.l_suppkey from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey where li.l_linenumber = 1 and li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber) ;
          Hide
          tedxu Ted Xu added a comment -

          Thanks Chao Sun.

          Looks like HIVE-9025, I will look into this.

          Show
          tedxu Ted Xu added a comment - Thanks Chao Sun . Looks like HIVE-9025 , I will look into this.
          Hide
          xuefuz Xuefu Zhang added a comment -

          Hi Ted Xu, I'm assigning this to you for investigation/fix. Thanks.

          Show
          xuefuz Xuefu Zhang added a comment - Hi Ted Xu , I'm assigning this to you for investigation/fix. Thanks.
          Hide
          tedxu Ted Xu added a comment -

          Thanks Xuefu Zhang, it is a bug of constant propagation optimizer.

          I'm running the unit tests and hopefully will get the patch ready soon.

          Show
          tedxu Ted Xu added a comment - Thanks Xuefu Zhang , it is a bug of constant propagation optimizer. I'm running the unit tests and hopefully will get the patch ready soon.
          Hide
          hiveqa 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/12691498/HIVE-9112.patch

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

          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynamic_partition_pruning
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynamic_partition_pruning_2
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_join_nullsafe
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_decimal_mapjoin
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vectorized_dynamic_partition_pruning
          org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_constprog_partitioner
          

          Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2330/testReport
          Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2330/console
          Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2330/

          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: 6 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12691498 - PreCommit-HIVE-TRUNK-Build

          Show
          hiveqa 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/12691498/HIVE-9112.patch ERROR: -1 due to 6 failed/errored test(s), 6747 tests executed Failed tests: org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynamic_partition_pruning org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynamic_partition_pruning_2 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_join_nullsafe org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_decimal_mapjoin org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vectorized_dynamic_partition_pruning org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_constprog_partitioner Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2330/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2330/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2330/ 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: 6 tests failed This message is automatically generated. ATTACHMENT ID: 12691498 - PreCommit-HIVE-TRUNK-Build
          Hide
          hiveqa 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/12691908/HIVE-9112.1.patch

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

          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynamic_partition_pruning
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynamic_partition_pruning_2
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_join_nullsafe
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_decimal_mapjoin
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_mapjoin_reduce
          org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vectorized_dynamic_partition_pruning
          org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_constprog_partitioner
          org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_ppd_join4
          org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_ppd_outer_join5
          org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_smb_mapjoin_25
          org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_vector_mapjoin_reduce
          org.apache.hadoop.hive.ql.TestMTQueries.testMTQueries1
          org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testMetastoreProxyUser
          org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testSaslWithHiveMetaStore
          org.apache.hive.jdbc.TestSSL.testSSLFetchHttp
          org.apache.hive.spark.client.TestSparkClient.testJobSubmission
          

          Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2359/testReport
          Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2359/console
          Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2359/

          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: 16 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12691908 - PreCommit-HIVE-TRUNK-Build

          Show
          hiveqa 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/12691908/HIVE-9112.1.patch ERROR: -1 due to 16 failed/errored test(s), 7311 tests executed Failed tests: org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynamic_partition_pruning org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_dynamic_partition_pruning_2 org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_join_nullsafe org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_decimal_mapjoin org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_mapjoin_reduce org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vectorized_dynamic_partition_pruning org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_constprog_partitioner org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_ppd_join4 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_ppd_outer_join5 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_smb_mapjoin_25 org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_vector_mapjoin_reduce org.apache.hadoop.hive.ql.TestMTQueries.testMTQueries1 org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testMetastoreProxyUser org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testSaslWithHiveMetaStore org.apache.hive.jdbc.TestSSL.testSSLFetchHttp org.apache.hive.spark.client.TestSparkClient.testJobSubmission Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2359/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2359/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2359/ 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: 16 tests failed This message is automatically generated. ATTACHMENT ID: 12691908 - PreCommit-HIVE-TRUNK-Build
          Hide
          ashutoshc Ashutosh Chauhan added a comment -

          Code changes looks good to me. Failures are just updates to golden files.
          Chao Sun since you found bug originally. Would you like to run this through your test cases to make sure those cases are covered.

          Show
          ashutoshc Ashutosh Chauhan added a comment - Code changes looks good to me. Failures are just updates to golden files. Chao Sun since you found bug originally. Would you like to run this through your test cases to make sure those cases are covered.
          Hide
          csun Chao Sun added a comment -

          Ashutosh Chauhan OK, will do it.

          Show
          csun Chao Sun added a comment - Ashutosh Chauhan OK, will do it.
          Hide
          csun Chao Sun added a comment -

          I ran a few tests and the issue is gone.
          Although ppd_multi_insert.q has a ordering issue: when mapred.reduce.tasks is set larger than one it generates same results with different order, even with SORT_QUERY_RESULTS. But, this is irrelevant and can be addressed in a separate JIRA.

          Show
          csun Chao Sun added a comment - I ran a few tests and the issue is gone. Although ppd_multi_insert.q has a ordering issue: when mapred.reduce.tasks is set larger than one it generates same results with different order, even with SORT_QUERY_RESULTS . But, this is irrelevant and can be addressed in a separate JIRA.
          Hide
          csun Chao Sun added a comment -

          Regenerated golden files.

          Show
          csun Chao Sun added a comment - Regenerated golden files.
          Hide
          ashutoshc Ashutosh Chauhan added a comment -

          cool. thanks for checking. +1

          Show
          ashutoshc Ashutosh Chauhan added a comment - cool. thanks for checking. +1
          Hide
          tedxu Ted Xu added a comment -
          Show
          tedxu Ted Xu added a comment - Thanks Chao Sun and Ashutosh Chauhan !
          Hide
          hiveqa 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/12692367/HIVE-9112.2.patch

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

          org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udaf_histogram_numeric
          org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_constprog_partitioner
          org.apache.hadoop.hive.ql.TestMTQueries.testMTQueries1
          

          Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2387/testReport
          Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2387/console
          Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2387/

          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: 3 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12692367 - PreCommit-HIVE-TRUNK-Build

          Show
          hiveqa 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/12692367/HIVE-9112.2.patch ERROR: -1 due to 3 failed/errored test(s), 7315 tests executed Failed tests: org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_udaf_histogram_numeric org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_constprog_partitioner org.apache.hadoop.hive.ql.TestMTQueries.testMTQueries1 Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2387/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2387/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2387/ 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: 3 tests failed This message is automatically generated. ATTACHMENT ID: 12692367 - PreCommit-HIVE-TRUNK-Build
          Hide
          ashutoshc Ashutosh Chauhan added a comment -

          Updated missed golden file update of constprog_partitioner.q
          Committed to trunk. Thanks, Ted!

          Show
          ashutoshc Ashutosh Chauhan added a comment - Updated missed golden file update of constprog_partitioner.q Committed to trunk. Thanks, Ted!
          Hide
          ashutoshc Ashutosh Chauhan added a comment -

          Vikram Dixit K OK for backport for 0.14 ?

          Show
          ashutoshc Ashutosh Chauhan added a comment - Vikram Dixit K OK for backport for 0.14 ?
          Hide
          ashutoshc Ashutosh Chauhan added a comment -

          Patch for 0.14-branch

          Show
          ashutoshc Ashutosh Chauhan added a comment - Patch for 0.14-branch
          Hide
          vikram.dixit Vikram Dixit K added a comment -

          +1 for 0.14

          Show
          vikram.dixit Vikram Dixit K added a comment - +1 for 0.14
          Hide
          ashutoshc Ashutosh Chauhan added a comment -

          committed to 0.14 branch

          Show
          ashutoshc Ashutosh Chauhan added a comment - committed to 0.14 branch
          Hide
          thejas Thejas M Nair added a comment -

          Updating release version for jiras resolved in 1.0.0 .

          Show
          thejas Thejas M Nair added a comment - Updating release version for jiras resolved in 1.0.0 .
          Hide
          thejas Thejas M Nair added a comment -

          This issue has been fixed in Apache Hive 1.0.0. If there is any issue with the fix, please open a new jira to address it.

          Show
          thejas Thejas M Nair added a comment - This issue has been fixed in Apache Hive 1.0.0. If there is any issue with the fix, please open a new jira to address it.

            People

            • Assignee:
              tedxu Ted Xu
              Reporter:
              csun Chao Sun
            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development