[
https://issues.apache.org/jira/browse/SPARK-16058?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Reynold Xin resolved SPARK-16058.
---------------------------------
Resolution: Fixed
Assignee: Xiao Li
Fix Version/s: 2.0.0
> JDBC Source: Wrong Results when lowerBound is larger than upperBound in
> Column Partitioning
> -------------------------------------------------------------------------------------------
>
> Key: SPARK-16058
> URL: https://issues.apache.org/jira/browse/SPARK-16058
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.0
> Reporter: Xiao Li
> Assignee: Xiao Li
> Priority: Critical
> Fix For: 2.0.0
>
>
> {noformat}
> spark.read.jdbc(
> url = urlWithUserAndPass,
> table = "TEST.seq",
> columnName = "id",
> lowerBound = 0,
> upperBound = 4,
> numPartitions = 0,
> connectionProperties = new Properties)
> {noformat}
> Currently, Spark SQL generates wrong results due to wrong partitions:
> {noformat}
> Part 0 id < 3 or id is null
> Part 1 id >= 3 AND id < 2
> Part 2 id >= 2
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
