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 2016/12/03 02:48:58 UTC
[jira] [Commented] (SPARK-12409) JDBC AND operator push down
[ https://issues.apache.org/jira/browse/SPARK-12409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15717219#comment-15717219 ]
Apache Spark commented on SPARK-12409:
--------------------------------------
User 'dongjoon-hyun' has created a pull request for this issue:
https://github.com/apache/spark/pull/16127
> 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
> Assignee: Takeshi Yamamuro
> Priority: Minor
> Fix For: 2.0.0
>
>
> 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