[ https://issues.apache.org/jira/browse/SPARK-12409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-12409: ------------------------------------ Assignee: 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 > Assignee: Apache Spark > 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org