[ 
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)

Reply via email to