hive-issues mailing list archives

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


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:
>             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

View raw message