You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (JIRA)" <ji...@apache.org> on 2016/10/08 12:38:20 UTC
[jira] [Closed] (SPARK-10899) Support JDBC pushdown for additional
commands
[ https://issues.apache.org/jira/browse/SPARK-10899?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon closed SPARK-10899.
--------------------------------
Resolution: Duplicate
I am closing this because I believe this is a subset of SPARK-12126
> Support JDBC pushdown for additional commands
> ---------------------------------------------
>
> Key: SPARK-10899
> URL: https://issues.apache.org/jira/browse/SPARK-10899
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 1.5.0
> Reporter: Victor May
> Priority: Minor
>
> Spark DataFrames currently support predicate push-down with JDBC sources but term predicate is used in a strict SQL meaning. It means it covers only WHERE clause. Moreover it looks like it is limited to the logical conjunction (no IN and OR I am afraid) and simple predicates.
> This creates a situation where a simple query such as "select * from table limit 100" could easily result in the database being overloaded when the table is large.
> This feature request is to expand the support for push-downs to additional SQL commands:
> -LIMIT
> -WHERE IN
> -WHERE NOT IN
> -GROUP BY
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org