You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Ian Cook (Jira)" <ji...@apache.org> on 2021/09/14 13:55:00 UTC
[jira] [Updated] (ARROW-13993) [C++] Hash aggregate function that
returns value from first row in group
[ https://issues.apache.org/jira/browse/ARROW-13993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Cook updated ARROW-13993:
-----------------------------
Description:
It would be nice to have a hash aggregate function that returns the first value of a column within each hash group.
If row order within groups is non-deterministic, then effectively this would return one arbitrary value. This is a very computationally cheap operation.
This can be quite useful when querying a non-normalized table. For example if you have a table with a {{country}} column and also a {{country_abbr}} column and you want to group by either/both of those columns, you could do
{code:java}
SELECT country, country_abbr FROM table GROUP BY country, country_abbr{code}
but it would be more efficient to do
{code:java}
SELECT country, first(country_abbr) FROM table GROUP BY country{code}
because then the engine does not need to scan all the values of the {{country_abbr}} column.
was:
It would be nice to have a hash aggregate function that returns the first value of a column within each hash group.
If row order within groups is non-deterministic, then effectively this would return one arbitrary value.
This can be quite useful when querying a non-normalized table. For example if you have a table with a {{country}} column and also a {{country_abbr}} column and you want to group by either/both of those columns, you could do
{code:java}
SELECT country, country_abbr FROM table GROUP BY country, country_abbr{code}
but it would be more efficient to do
{code:java}
SELECT country, first(country_abbr) FROM table GROUP BY country{code}
because then the engine does not need to scan all the values of the {{country_abbr}} column.
> [C++] Hash aggregate function that returns value from first row in group
> ------------------------------------------------------------------------
>
> Key: ARROW-13993
> URL: https://issues.apache.org/jira/browse/ARROW-13993
> Project: Apache Arrow
> Issue Type: Improvement
> Components: C++
> Reporter: Ian Cook
> Priority: Major
>
> It would be nice to have a hash aggregate function that returns the first value of a column within each hash group.
> If row order within groups is non-deterministic, then effectively this would return one arbitrary value. This is a very computationally cheap operation.
> This can be quite useful when querying a non-normalized table. For example if you have a table with a {{country}} column and also a {{country_abbr}} column and you want to group by either/both of those columns, you could do
> {code:java}
> SELECT country, country_abbr FROM table GROUP BY country, country_abbr{code}
> but it would be more efficient to do
> {code:java}
> SELECT country, first(country_abbr) FROM table GROUP BY country{code}
> because then the engine does not need to scan all the values of the {{country_abbr}} column.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)