You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (JIRA)" <ji...@apache.org> on 2015/12/18 18:37:46 UTC
[jira] [Assigned] (SPARK-12409) JDBC AND operator push down
[ https://issues.apache.org/jira/browse/SPARK-12409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-12409:
------------------------------------
Assignee: (was: Apache Spark)
> JDBC AND operator push down
> ----------------------------
>
> Key: SPARK-12409
> URL: https://issues.apache.org/jira/browse/SPARK-12409
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Reporter: Huaxin Gao
> Priority: Minor
>
> For simple AND such as
> select * from test where THEID = 1 AND NAME = 'fred',
> The filters pushed down to JDBC layers are EqualTo(THEID,1), EqualTo(Name,fred). These are handled OK by the current code.
> For query such as
> SELECT * FROM foobar WHERE THEID = 1 OR NAME = 'mary' AND THEID = 2" ,
> the filter is Or(EqualTo(THEID,1),And(EqualTo(NAME,mary),EqualTo(THEID,2)))
> So need to add And filter in JDBC layer.
--
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