[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16657181#comment-16657181 ] Hive QA commented on HIVE-20775: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 10m 4s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 5s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 40s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 4s{color} | {color:blue} ql in master has 2318 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 58s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 24s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 1s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 1s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 38s{color} | {color:red} ql: The patch generated 3 new + 123 unchanged - 3 fixed = 126 total (was 126) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 4m 11s{color} | {color:red} ql generated 2 new + 2316 unchanged - 2 fixed = 2318 total (was 2318) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 54s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 25m 39s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:ql | | | Dead store to tsRowSize in org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:[line 1427] | | | Should org.apache.hadoop.hive.ql.parse.TezCompiler$SemijoinOperatorInfo be a _static_ inner class? At TezCompiler.java:inner class? At TezCompiler.java:[lines 1612-1618] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-14571/dev-support/hive-personality.sh | | git revision | master / bd3c05d | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-14571/yetus/diff-checkstyle-ql.txt | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-14571/yetus/new-findbugs-ql.html | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14571/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16657236#comment-16657236 ] Hive QA commented on HIVE-20775: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12944637/HIVE-20775.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 129 failed/errored test(s), 14754 tests executed *Failed tests:* {noformat} TestAMReporter - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestAddResource - did not produce a TEST-*.xml file (likely timed out) (batchId=318) TestBeeLineWithArgs - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestBeelineConnectionUsingHiveSite - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestBeelinePasswordOption - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestBeelineWithUserHs2ConnectionFile - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestBuddyAllocator - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestBuddyAllocatorForceEvict - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestCleanerWithReplication - did not produce a TEST-*.xml file (likely timed out) (batchId=244) TestCreateUdfEntities - did not produce a TEST-*.xml file (likely timed out) (batchId=244) TestCustomAuthentication - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestDDLWithRemoteMetastoreSecondNamenode - did not produce a TEST-*.xml file (likely timed out) (batchId=244) TestDropMacroDesc - did not produce a TEST-*.xml file (likely timed out) (batchId=318) TestEvictingPriorityBlockingQueue - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestExportImport - did not produce a TEST-*.xml file (likely timed out) (batchId=244) TestFirstInFirstOutComparator - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestHiveOperationType - did not produce a TEST-*.xml file (likely timed out) (batchId=318) TestIncrementalObjectSizeEstimator - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestInformationSchemaWithPrivilege - did not produce a TEST-*.xml file (likely timed out) (batchId=254) TestLlapDaemonProtocolServerImpl - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestLlapSignerImpl - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestLlapStatusServiceDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestLlapTokenChecker - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestLlapWebServices - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestLowLevelCacheImpl - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestLowLevelLrfuCachePolicy - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestMetaStoreLimitPartitionRequest - did not produce a TEST-*.xml file (likely timed out) (batchId=244) TestMiniHS2StateWithNoZookeeper - did not produce a TEST-*.xml file (likely timed out) (batchId=252) TestMiniLlapLocalCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=178) [smb_mapjoin_15.q,insert_values_partitioned.q,vector_orc_merge_incompat_schema.q,selectDistinctStar.q,strict_managed_tables1.q,bucket4.q,vectorized_distinct_gby.q,vector_groupby_mapjoin.q,insert_values_dynamic_partitioned.q,autoColumnStats_10.q,tez_vector_dynpart_hashjoin_1.q,filter_join_breaktask2.q,union_rowcounts.q,mm_conversions.q,multiMapJoin2.q,filter_join_breaktask.q,column_table_stats.q,update_access_time_non_current_db.q,schema_evol_orc_nonvec_part.q,dynamic_semijoin_reduction_2.q,alter_merge_2_orc.q,bucket_num_reducers2.q,union4.q,auto_sortmerge_join_8.q,llap_text.q,dec_str.q,dynamic_semijoin_reduction_sw2.q,change_allowincompatible_vectorization_false_date.q,dynamic_semijoin_reduction_3.q,vector_decimal_udf2.q] TestOperationLoggingAPIWithMr - did not produce a TEST-*.xml file (likely timed out) (batchId=254) TestOperationLoggingLayout - did not produce a TEST-*.xml file (likely timed out) (batchId=254) TestOperatorCmp - did not produce a TEST-*.xml file (likely timed out) (batchId=318) TestOrcMetadataCache - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestQueryDisplay - did not produce a TEST-*.xml file (likely timed out) (batchId=254) TestQueryIdentifier - did not produce a TEST-*.xml file (likely timed out) (batchId=330) TestReplicationOnHDFSEncryptedZones - did not produce a TEST-*.xml file (likely timed out) (batchId=244) TestSQLStdHiveAccessControllerCLI - did not produce a TEST-*.xml file (likely timed out) (batchId=318) TestSQLStdHiveAccessControllerHS2 - did not produce a TEST-*.xml file (likely timed out) (batchId=318) TestSchemaTool - did not produce a
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16673851#comment-16673851 ] Hive QA commented on HIVE-20775: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 38s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 0s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 37s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 49s{color} | {color:blue} ql in master has 2315 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 53s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 21s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 1s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 1s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 39s{color} | {color:red} ql: The patch generated 3 new + 124 unchanged - 3 fixed = 127 total (was 127) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 4m 1s{color} | {color:red} ql generated 2 new + 2313 unchanged - 2 fixed = 2315 total (was 2315) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 55s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 23m 31s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:ql | | | Dead store to tsRowSize in org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:[line 1451] | | | Should org.apache.hadoop.hive.ql.parse.TezCompiler$SemijoinOperatorInfo be a _static_ inner class? At TezCompiler.java:inner class? At TezCompiler.java:[lines 1629-1643] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-14713/dev-support/hive-personality.sh | | git revision | master / f3fab45 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-14713/yetus/diff-checkstyle-ql.txt | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-14713/yetus/new-findbugs-ql.html | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14713/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16673872#comment-16673872 ] Hive QA commented on HIVE-20775: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12946310/HIVE-20775.01.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 15515 tests executed *Failed tests:* {noformat} TestMiniDruidCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=195) [druidmini_dynamic_partition.q,druidmini_test_ts.q,druidmini_expressions.q,druidmini_test_alter.q,druidmini_test_insert.q] org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[dynamic_semijoin_user_level] (batchId=155) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_dynamic_semijoin_reduction] (batchId=159) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[cbo_query23] (batchId=272) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[cbo_query54] (batchId=272) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query64] (batchId=272) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query95] (batchId=272) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[cbo_query54] (batchId=272) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14713/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14713/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14713/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 8 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12946310 - PreCommit-HIVE-Build > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16676749#comment-16676749 ] Hive QA commented on HIVE-20775: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 45s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 3s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 37s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 45s{color} | {color:blue} ql in master has 2315 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 52s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 24s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 58s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 58s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 36s{color} | {color:red} ql: The patch generated 4 new + 124 unchanged - 3 fixed = 128 total (was 127) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 3m 49s{color} | {color:red} ql generated 2 new + 2313 unchanged - 2 fixed = 2315 total (was 2315) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 23m 18s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:ql | | | Dead store to tsRowSize in org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:[line 1452] | | | Should org.apache.hadoop.hive.ql.parse.TezCompiler$SemijoinOperatorInfo be a _static_ inner class? At TezCompiler.java:inner class? At TezCompiler.java:[lines 1680-1694] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-14768/dev-support/hive-personality.sh | | git revision | master / 353c55e | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-14768/yetus/diff-checkstyle-ql.txt | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-14768/yetus/new-findbugs-ql.html | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14768/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This messag
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16676794#comment-16676794 ] Hive QA commented on HIVE-20775: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12947009/HIVE-20775.02.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 15525 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[acid_no_buckets] (batchId=176) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dpp] (batchId=168) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_partition_pruning] (batchId=166) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_semijoin_reduction] (batchId=171) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_dynamic_partition_pruning] (batchId=166) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query64] (batchId=272) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14768/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14768/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14768/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 6 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12947009 - PreCommit-HIVE-Build > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16678248#comment-16678248 ] Hive QA commented on HIVE-20775: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 24s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 3s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 35s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 32s{color} | {color:blue} ql in master has 2315 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 54s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 17s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 0s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 0s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 37s{color} | {color:red} ql: The patch generated 4 new + 124 unchanged - 3 fixed = 128 total (was 127) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 1s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 3m 51s{color} | {color:red} ql generated 2 new + 2313 unchanged - 2 fixed = 2315 total (was 2315) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 53s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 12s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 22m 41s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:ql | | | Dead store to tsRowSize in org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:[line 1452] | | | Should org.apache.hadoop.hive.ql.parse.TezCompiler$SemijoinOperatorInfo be a _static_ inner class? At TezCompiler.java:inner class? At TezCompiler.java:[lines 1688-1702] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-14790/dev-support/hive-personality.sh | | git revision | master / 6d713b6 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-14790/yetus/diff-checkstyle-ql.txt | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-14790/yetus/new-findbugs-ql.html | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14790/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been ma
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16678323#comment-16678323 ] Hive QA commented on HIVE-20775: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12947152/HIVE-20775.03.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 15524 tests executed *Failed tests:* {noformat} TestMiniDruidCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=196) [druidmini_masking.q,druidmini_test1.q,druidkafkamini_basic.q,druidmini_joins.q,druid_timestamptz.q] org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[dynamic_semijoin_user_level] (batchId=155) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_limit] (batchId=182) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_dynamic_semijoin_reduction] (batchId=159) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query64] (batchId=272) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query95] (batchId=272) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14790/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14790/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14790/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 6 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12947152 - PreCommit-HIVE-Build > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16682712#comment-16682712 ] Hive QA commented on HIVE-20775: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || | {color:red}-1{color} | {color:red} patch {color} | {color:red} 0m 11s{color} | {color:red} /data/hiveptest/logs/PreCommit-HIVE-Build-14870/patches/PreCommit-HIVE-Build-14870.patch does not apply to master. Rebase required? Wrong Branch? See http://cwiki.apache.org/confluence/display/Hive/HowToContribute for help. {color} | \\ \\ || Subsystem || Report/Notes || | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-14870/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.04.patch, HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16682727#comment-16682727 ] Hive QA commented on HIVE-20775: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12947720/HIVE-20775.04.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 15521 tests executed *Failed tests:* {noformat} TestAlterTableMetadata - did not produce a TEST-*.xml file (likely timed out) (batchId=250) TestAutoPurgeTables - did not produce a TEST-*.xml file (likely timed out) (batchId=250) TestLocationQueries - did not produce a TEST-*.xml file (likely timed out) (batchId=250) TestReplAcidTablesWithJsonMessage - did not produce a TEST-*.xml file (likely timed out) (batchId=250) TestSemanticAnalyzerHookLoading - did not produce a TEST-*.xml file (likely timed out) (batchId=250) org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[dynamic_semijoin_user_level] (batchId=155) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_dynamic_semijoin_reduction] (batchId=159) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query95] (batchId=272) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/14870/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14870/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14870/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 8 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12947720 - PreCommit-HIVE-Build > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.04.patch, HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16695251#comment-16695251 ] Jesus Camacho Rodriguez commented on HIVE-20775: [~ashutoshc], I have separated this code from HIVE-20783, I have added more comments as you mentioned in RB, and I have created HIVE-20957 as a follow-up. > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.04.patch, HIVE-20775.05.patch, > HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16695266#comment-16695266 ] Hive QA commented on HIVE-20775: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 1s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 38s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 0s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 39s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 43s{color} | {color:blue} ql in master has 2312 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 21s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 3s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 3s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 39s{color} | {color:red} ql: The patch generated 4 new + 123 unchanged - 2 fixed = 127 total (was 125) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 1s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 3m 57s{color} | {color:red} ql generated 2 new + 2310 unchanged - 2 fixed = 2312 total (was 2312) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 55s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 23m 28s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:ql | | | Dead store to tsRowSize in org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:[line 1455] | | | Should org.apache.hadoop.hive.ql.parse.TezCompiler$SemijoinOperatorInfo be a _static_ inner class? At TezCompiler.java:inner class? At TezCompiler.java:[lines 1656-1670] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15033/dev-support/hive-personality.sh | | git revision | master / f5b14fc | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-15033/yetus/diff-checkstyle-ql.txt | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-15033/yetus/new-findbugs-ql.html | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15033/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.04.patch, HIVE-20775.05.patch, > HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into a
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16695302#comment-16695302 ] Hive QA commented on HIVE-20775: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12949114/HIVE-20775.05.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:red}ERROR:{color} -1 due to 5 failed/errored test(s), 15546 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dynamic_semijoin_reduction] (batchId=171) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_dynamic_semijoin_reduction] (batchId=159) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query64] (batchId=273) org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query95] (batchId=273) org.apache.hadoop.hive.cli.TestTezPerfConstraintsCliDriver.testCliDriver[query64] (batchId=273) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15033/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15033/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15033/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 5 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12949114 - PreCommit-HIVE-Build > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.04.patch, HIVE-20775.05.patch, > HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16695305#comment-16695305 ] Ashutosh Chauhan commented on HIVE-20775: - +1 > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.04.patch, HIVE-20775.05.patch, > HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16699620#comment-16699620 ] Hive QA commented on HIVE-20775: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 34s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 1s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 38s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 45s{color} | {color:blue} ql in master has 2312 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 54s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 23s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 6s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 5s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 38s{color} | {color:red} ql: The patch generated 3 new + 123 unchanged - 2 fixed = 126 total (was 125) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 1s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:red}-1{color} | {color:red} findbugs {color} | {color:red} 4m 1s{color} | {color:red} ql generated 2 new + 2310 unchanged - 2 fixed = 2312 total (was 2312) {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 56s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 23m 31s{color} | {color:black} {color} | \\ \\ || Reason || Tests || | FindBugs | module:ql | | | Dead store to tsRowSize in org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:org.apache.hadoop.hive.ql.parse.TezCompiler.getBloomFilterBenefit(SelectOperator, ExprNodeDesc, Statistics, ExprNodeDesc) At TezCompiler.java:[line 1456] | | | Should org.apache.hadoop.hive.ql.parse.TezCompiler$SemijoinOperatorInfo be a _static_ inner class? At TezCompiler.java:inner class? At TezCompiler.java:[lines 1661-1675] | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u1 (2016-09-03) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-15062/dev-support/hive-personality.sh | | git revision | master / 0fee288 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-15062/yetus/diff-checkstyle-ql.txt | | findbugs | http://104.198.109.242/logs//PreCommit-HIVE-Build-15062/yetus/new-findbugs-ql.html | | modules | C: ql U: ql | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-15062/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.04.patch, HIVE-20775.05.patch, > HIVE-20775.06.patch, HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the
[jira] [Commented] (HIVE-20775) Factor cost of each SJ reduction when costing a follow-up reduction
[ https://issues.apache.org/jira/browse/HIVE-20775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16699662#comment-16699662 ] Hive QA commented on HIVE-20775: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12949535/HIVE-20775.06.patch {color:red}ERROR:{color} -1 due to no test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 15539 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/15062/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/15062/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-15062/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12949535 - PreCommit-HIVE-Build > Factor cost of each SJ reduction when costing a follow-up reduction > --- > > Key: HIVE-20775 > URL: https://issues.apache.org/jira/browse/HIVE-20775 > Project: Hive > Issue Type: Bug > Components: Physical Optimizer >Reporter: Jesus Camacho Rodriguez >Assignee: Jesus Camacho Rodriguez >Priority: Major > Attachments: HIVE-20775.01.patch, HIVE-20775.02.patch, > HIVE-20775.03.patch, HIVE-20775.04.patch, HIVE-20775.05.patch, > HIVE-20775.06.patch, HIVE-20775.patch > > > Currently, while costing the SJ in a plan, the stats of the a TS that is > reduced by a SJ are not adjusted after we have decided to keep a SJ in the > tree. Ideally, we could adjust the stats to take into account decisions that > have already been made. -- This message was sent by Atlassian JIRA (v7.6.3#76005)