Huaxin Gao created SPARK-12409:
----------------------------------
Summary: 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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
