SQL

[Madabhattula Rajesh Kumar]

Hi,

To read data from oracle. I am using sqlContext. Below is the method
signature.

Is lowerBound and upperBound values are belongs to actual table lower and
upper value of column (or) We can give any numbers

Please clarify.

sqlContext.read.format("jdbc").options(
      Map("url" -> "jdbcURL",
        "dbtable" -> query,
        "driver" -> "oracle.jdbc.driver.OracleDriver",
        "user" -> "jdbcUsername",
        "password" ->"jdbcPassword",
        "numPartitions" -> "10",
        "lowerBound" -> "1",
        "upperBound" -> "1000",
        "partitionColumn" -> "col1" )).load
  }

Regards,
Rajesh