hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zoltan Haindrich (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-19824) Improve online datasize estimations for MapJoins
Date Mon, 11 Jun 2018 20:59:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-19824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16508730#comment-16508730
] 

Zoltan Haindrich commented on HIVE-19824:
-----------------------------------------

[~sershe] I'm not sure; but I feel that you might have wanted to note this to the other ticket
(HIVE-19823); this is only about correcting the used memory estimation in {{ConvertMapJoin}}
- to prevent the conversion of joins which will eventually lead to an OOM...

> Improve online datasize estimations for MapJoins
> ------------------------------------------------
>
>                 Key: HIVE-19824
>                 URL: https://issues.apache.org/jira/browse/HIVE-19824
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Zoltan Haindrich
>            Assignee: Zoltan Haindrich
>            Priority: Major
>         Attachments: HIVE-19824.01.patch, HIVE-19824.01wip01.patch, HIVE-19824.01wip01.patch
>
>
> Statistics.datasize() only accounts for "real" data size; but for example handling 1M
rows might introduce some datastructure overhead...if the "real" data is small - even this
overhead might become the real memory usage
> for 6.5M rows of (int,int) the estimation is 52MB
> in reality this eats up ~260MB from which 210MB is used to service the hashmap functionality
to that many rows.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message