RE: Data from Mysql using JdbcRDD

2014-08-01 Thread srinivas
Hi Thanks Alli have few more questions on this suppose i don't want to pass where caluse in my sql and is their a way that i can do this. Right now i am trying to modify JdbcRDD class by removing all the paramaters for lower bound and upper bound. But i am getting run time exceptions. Is

Re: Data from Mysql using JdbcRDD

2014-07-30 Thread chaitu reddy
Kc On Jul 30, 2014 3:55 PM, srinivas kusamsrini...@gmail.com wrote: Hi, I am trying to get data from mysql using JdbcRDD using code The table have three columns val url = jdbc:mysql://localhost:3306/studentdata val username = root val password = root val mysqlrdd = new

Re: Data from Mysql using JdbcRDD

2014-07-30 Thread Josh Mahonin
Hi Srini, I believe the JdbcRDD requires input splits based on ranges within the query itself. As an example, you could adjust your query to something like: SELECT * FROM student_info WHERE id = ? AND id = ? Note that the values you've passed in '1, 20, 2' correspond to the lower bound index,