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

["Reynold Xin (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-12409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Reynold Xin resolved SPARK-12409.
---------------------------------
       Resolution: Fixed
         Assignee: Takeshi Yamamuro
    Fix Version/s: 2.0.0

> 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