[jira] [Commented] (SPARK-38852) Better Data Source V2 operator pushdown framework

["Erik Krogen (Jira)" <ji...@apache.org>]

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

Erik Krogen commented on SPARK-38852:
-------------------------------------

What's the relationship between this and SPARK-38788? Seems like they are laying out the same goal?

> Better Data Source V2 operator pushdown framework
> -------------------------------------------------
>
>                 Key: SPARK-38852
>                 URL: https://issues.apache.org/jira/browse/SPARK-38852
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.3.0
>            Reporter: jiaan.geng
>            Priority: Major
>
> Currently, Spark supports push down Filters and Aggregates to data source.
> However, the Data Source V2 operator pushdown framework has the following shortcomings:
> # Only simple filter and aggregate are supported, which makes it impossible to apply in most scenarios
> # The incompatibility of SQL syntax makes it impossible to apply in most scenarios
> # Aggregate push down does not support multiple partitions of data sources
> # Spark's additional aggregate will cause some overhead
> # Limit push down is not supported
> # Top n push down is not supported
> # Offset push down is not supported



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

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