[jira] [Commented] (SPARK-12409) JDBC AND operator push down

["Huaxin Gao (JIRA)" <ji...@apache.org>]

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

Huaxin Gao commented on SPARK-12409:
------------------------------------

I will submit a PR soon. 

> 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