RE: Data from Mysql using JdbcRDD

2014-08-04 Thread chutium
wer) +if (parameterCount > 1) stmt.setLong(2, part.upper) -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Data-from-Mysql-using-JdbcRDD-tp10994p11331.html Sent from the Apache Spark User List mailing list archive at Nabb

RE: Data from Mysql using JdbcRDD

2014-08-01 Thread srinivas
. Is their any work around solution to do normal sql queries with or without using where clause or like selecting values for particular value? Please help -Srini. -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Data-from-Mysql-using-JdbcRDD-tp10994p11174.html

RE: Data from Mysql using JdbcRDD

2014-07-30 Thread Cheng, Hao
Probably you need to update the SQL like "SELECT * FROM student_info where id >= ? and id <= ?". -Original Message- From: srinivas [mailto:kusamsrini...@gmail.com] Sent: Thursday, July 31, 2014 6:55 AM To: u...@spark.incubator.apache.org Subject: Data from Mysql using Jd

Re: Data from Mysql using JdbcRDD

2014-07-30 Thread Josh Mahonin
wrote: > Kc > On Jul 30, 2014 3:55 PM, "srinivas" 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&

Re: Data from Mysql using JdbcRDD

2014-07-30 Thread chaitu reddy
Kc On Jul 30, 2014 3:55 PM, "srinivas" 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" &

Data from Mysql using JdbcRDD

2014-07-30 Thread srinivas
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 org.apache.spark.rdd.JdbcRDD(