You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Sun BiaoBiao (Jira)" <ji...@apache.org> on 2022/07/30 03:21:00 UTC

[jira] [Commented] (SPARK-39908) Translate common used aggregate functions for pushdown (non ANSI)

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

Sun BiaoBiao commented on SPARK-39908:
--------------------------------------

all   aggregate functions doesn't follow ANSI  list:

 

 
||name||comment||
|count_if|wil be repaced by count  at runtime, skip  |
|first_value| |
|any_value| |
|kurtosis| |
|last| |
|last_value| |
|max_by| |
|min_by| |
|percentile| |
|median| |
|collect_list| |
|array_agg| |
|collect_set| |
|bool_and|wil be repaced by   Min at runtime, skip|
|any|wil be repaced by   Max at runtime , skip|
|some|wil be repaced by Max  at runtime, skip|
|bool_or|wil be repaced by Max  at runtime, skip|
|every|wil be repaced by Min  at runtime, skip|
| |Col A2|

 

 

> Translate common used aggregate functions for pushdown (non ANSI)
> -----------------------------------------------------------------
>
>                 Key: SPARK-39908
>                 URL: https://issues.apache.org/jira/browse/SPARK-39908
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.4.0
>            Reporter: jiaan.geng
>            Priority: Major
>
> Currently, Spark have a lot of common used aggregate functions doesn't follow ANSI standard.
> Because these aggregate functions are common used, we should push down them.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org