[
https://issues.apache.org/jira/browse/HIVE-25335?focusedWorklogId=754531&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-754531
]
ASF GitHub Bot logged work on HIVE-25335:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 08/Apr/22 11:28
Start Date: 08/Apr/22 11:28
Worklog Time Spent: 10m
Work Description: zhengchenyu commented on PR #2490:
URL: https://github.com/apache/hive/pull/2490#issuecomment-1092763873
@zabetak Sorry for miss this issue long time, Can you help me reopen this PR?
Issue Time Tracking
-------------------
Worklog Id: (was: 754531)
Time Spent: 2h 20m (was: 2h 10m)
> 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: 2h 20m
> 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.1#820001)
