Hi All - I try to use the new SQLContext API for populating DataFrame from jdbc data source. like this:
val jdbcDF = sqlContext.jdbc(url = "jdbc:postgresql://localhost:5430/dbname?user=user&password=111", table = "se_staging.exp_table3" ,columnName="cs_id",lowerBound=1 ,upperBound = 10000, numPartitions=12 ) No matter how I set lower and upper bounds I always get all the rows from my table. The API is marked as experimental so I assume there might by some bugs in it but did anybody come across a similar issue? Thanks! Marek