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