GitHub user sureshthalamati opened a pull request:
https://github.com/apache/spark/pull/15662
[SPARK-18141][SQL] Fix to quote column names in the predicate clause of
the JDBC RDD generated sql statement
## What changes were proposed in this pull request?
SQL query generated for the JDBC data source is not quoting columns in the
predicate clause. When the source table has quoted column names, spark jdbc
read fails with column not found error incorrectly.
This PR fixes by quoting column names in the generated SQL for predicate
clause when filters are pushed down to the data source..
## How was this patch tested?
Added new test case to the JdbcSuite
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sureshthalamati/spark
filter_quoted_cols-SPARK-18141
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/15662.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #15662
----
commit 0944e055b72adadb9647007f03b8cea81faf3c77
Author: sureshthalamati <[email protected]>
Date: 2016-10-27T18:27:34Z
[SPARK-18141][SQL] Fix to quote column names in the predicate clause of the
JDBC RDD generated sql statement
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
