You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Mostafa Mokhtar (JIRA)" <ji...@apache.org> on 2018/06/28 21:29:00 UTC
[jira] [Resolved] (IMPALA-2712) Investigate increasing batch size
[ https://issues.apache.org/jira/browse/IMPALA-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mostafa Mokhtar resolved IMPALA-2712.
-------------------------------------
Resolution: Won't Fix
> Investigate increasing batch size
> ---------------------------------
>
> Key: IMPALA-2712
> URL: https://issues.apache.org/jira/browse/IMPALA-2712
> Project: IMPALA
> Issue Type: Task
> Components: Perf Investigation
> Affects Versions: Impala 2.2
> Reporter: Mostafa Mokhtar
> Assignee: Mostafa Mokhtar
> Priority: Minor
> Labels: performance
>
> Investigate increasing batch size for better performance.
> Initial results
> |Query||10,000,000||1,000,000||100,000||10,000||1,000||100||10|
> |broadcast_join_1|5|4|4|4|3|3|33|
> |broadcast_join_2|9|7|8|8|12|18|96|
> |broadcast_join_3|55|63|67|73|81|133|556|
> |exchange_broadcast| |115.59|118|119|149|285|1,193|
> |exchange_shuffle|196|187|186|191|191.81| | |
> |filter_bigint_non_selective|9|6|6|6|7|31|275|
> |filter_bigint_selective|3|3|3|3|3|3|13|
> |filter_decimal_non_selective|3|3|3|3|3|9|65|
> |filter_decimal_selective|3|3|3|3|3|10|46|
> |filter_string_non_selective|2|2|2|2|3|17|143|
> |filter_string_selective|2|2|2|2|2|7|34|
> |groupBy_bigint_highndv|58|55|55|58|55|69|254|
> |groupBy_bigint_lowndv|13|9|9|9|10|26|202|
> |groupBy_decimal_highndv|116|87|81|105|102|103|257|
> |groupBy_decimal_lowndv|30|27|28|29|33|45|217|
> |groupBy_spilling| | |566|534|527|523|546|
> |insert_partitioned|392|383|375|385|483|451|486|
> |insert|392|383|375|385|483|451|486|
> |orderby_all| | |158|176|173|191|323|
> |orderby_bigint|30|34|34|35|34|49|281|
> |shuffle_join_one_to_many_string_with_groupby|554|568|613|561|549|577|739|
> |shuffle_join_union_all_with_groupby| | |97|109|122|119|262|
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org