[ https://issues.apache.org/jira/browse/HIVE-25335?focusedWorklogId=774336&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-774336 ]
ASF GitHub Bot logged work on HIVE-25335: ----------------------------------------- Author: ASF GitHub Bot Created on: 25/May/22 03:22 Start Date: 25/May/22 03:22 Worklog Time Spent: 10m Work Description: zhengchenyu commented on PR #3292: URL: https://github.com/apache/hive/pull/3292#issuecomment-1136682080 > @zhengchenyu I am not sure what exactly do you mean by saying the unit tests are working in your environment. If you check the failed tests you will see a lot related to the `TestMiniLlapLocalCliDriver`. If you want to run these tests and update the plans you don't need Jenkins or anything else. You can do it by following the steps below: > > ``` > mvn clean install -DskipTests -Pitests > cd itests/qtest > mvn test -Dtest=TestMiniLlapLocalCliDriver -Dtest.output.overwrite > ``` > > If you want to run specific tests then you can use the `-Dqfile` option. For more info have a look here: https://cwiki.apache.org/confluence/display/Hive/HiveDeveloperFAQ#HiveDeveloperFAQ-HowdoIruntheclientpositive/clientnegativeunittests? @zabetak In our compile server, I just test the uni-test in this way. Then all pass. Seems jenkins fail on this scripts. ``` # removes all stdout and err for passed tests xmlstarlet ed -L -d 'testsuite/testcase/system-out[count(../failure)=0]' -d 'testsuite/testcase/system-err[count(../failure)=0]' `find . -name 'TEST*xml' -path '*/surefire-reports/*'` # remove all output.txt files find . -name '*output.txt' -path '*/surefire-reports/*' -exec unlink "{}" \\; ``` I also execute this scripts, then pass. I don't know the difference between my compile server and this jenkins pipeline. Maybe I should setup a whole jenkins pipeline to reproduce this error. But jenkinsfile on my jenkins server run failed. Issue Time Tracking ------------------- Worklog Id: (was: 774336) Time Spent: 3h 10m (was: 3h) > Unreasonable setting reduce number, when join big size table(but small row > count) and small size table > ------------------------------------------------------------------------------------------------------ > > Key: HIVE-25335 > URL: https://issues.apache.org/jira/browse/HIVE-25335 > Project: Hive > Issue Type: Improvement > Reporter: zhengchenyu > Assignee: zhengchenyu > Priority: Major > Labels: pull-request-available > Attachments: HIVE-25335.001.patch > > Time Spent: 3h 10m > Remaining Estimate: 0h > > I found an application which is slow in our cluster, because the proccess > bytes of one reduce is very huge, but only two reduce. > when I debug, I found the reason. Because in this sql, one big size table > (about 30G) with few row count(about 3.5M), another small size table (about > 100M) have more row count (about 3.6M). So JoinStatsRule.process only use > 100M to estimate reducer's number. But we need to process 30G byte in fact. -- This message was sent by Atlassian Jira (v8.20.7#820007)