You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "izveigor (via GitHub)" <gi...@apache.org> on 2023/08/07 07:52:50 UTC

[GitHub] [arrow-datafusion] izveigor opened a new issue, #7214: Implement array aggregate functions

izveigor opened a new issue, #7214:
URL: https://github.com/apache/arrow-datafusion/issues/7214

   ### Is your feature request related to a problem or challenge?
   
   Arrow DataFusion has a lot of aggregate functions for scalars and columns. We can compute an aggregate function with array by `unnest` funciton, but in my opinion it would be better to implement DuckDB methods to use different `list_` aggregate functions.
   
   ## List
   
   The full list of array aggregate functions:
   
   ### General:
   
   - [ ] `array_avg` (alias: `list_avg`)
   - [ ] `array_bit_and` (alias: `list_bit_and`)
   - [ ] `array_bit_or` (alias: `list_bit_or`)
   - [ ] `array_bit_xor` (alias: `list_bit_xor`)
   - [ ] `array_bool_and` (alias: `list_bool_and`)
   - [ ] `array_bool_or` (alias: `list_bool_or`)
   - [ ] `array_count` (alias: `list_count`)
   - [ ] `array_max` (alias: `list_max`)
   - [ ] `array_mean` (alias: `list_mean`)
   - [ ] `array_median` (alias: `list_median`)
   - [ ] `array_min` (alias: `list_min`)
   - [ ] `array_sum` (alias: `list_sum`)
   
   ### Statistical:
   
   - [ ] `array_stddev` (alias: `list_stddev`)
   - [ ] `array_stddev_pop` (alias: `list_stddev_pop`)
   - [ ] `array_stddev_samp` (alias: `list_stddev_samp`)
   - [ ] `array_var` (alias: `list_var`)
   - [ ] `array_var_pop` (alias: `list_var_pop`)
   - [ ] `array_var_samp` (alias: `list_var_samp`)
   
   ### Approximate:
   
   - [ ] `array_approx_distinct` (alias: `list_approx_distinct`)
   - [ ] `array_approx_median` (alias: `list_approx_median`)
   
   
   ### Describe the solution you'd like
   
   _No response_
   
   ### Describe alternatives you've considered
   
   _No response_
   
   ### Additional context
   
   DuckDB documentation: https://duckdb.org/docs/sql/functions/nested;
   Apache Arrow DataFusion aggregate functions: https://arrow.apache.org/datafusion/user-guide/sql/aggregate_functions.html


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] Implement array aggregate functions [arrow-datafusion]

Posted by "edmondop (via GitHub)" <gi...@apache.org>.
edmondop commented on issue #7214:
URL: https://github.com/apache/arrow-datafusion/issues/7214#issuecomment-1807193083

   This seems useful and something I can look into, can I pick it up @jayzhan211 ?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] Implement array aggregate functions [arrow-datafusion]

Posted by "jayzhan211 (via GitHub)" <gi...@apache.org>.
jayzhan211 commented on issue #7214:
URL: https://github.com/apache/arrow-datafusion/issues/7214#issuecomment-1807282486

   > This seems useful and something I can look into, can I pick it up @jayzhan211 ?
   
   We have starting from `sum` but meet quite many challenge here. You can look into this first https://github.com/apache/arrow-datafusion/pull/7242


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] Implement array aggregate functions [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #7214:
URL: https://github.com/apache/datafusion/issues/7214#issuecomment-2713713581

   I think we are done / no more work planned here


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] Implement array aggregate functions [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #7214: Implement array aggregate functions
URL: https://github.com/apache/datafusion/issues/7214


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org