Xiao Li created SPARK-16058:
-------------------------------
Summary: 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
{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]
