https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-MYSQL-table-in-to-RDD/m-p/166320#M53814 <P>There is a JDBC RDD function:</P><PRE>newJdbcRDD(sc: SparkContext, getConnection: () ⇒ Connection, sql: String, lowerBound: Long, upperBound: Long, numPartitions: Int, mapRow: (ResultSet) ⇒ T = JdbcRDD.resultSetToObjectArray)(implicit arg0: ClassTag[T])</PRE> Thu, 09 Feb 2017 00:48:23 GMT jwiden 2017-02-09T00:48:23Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-MYSQL-table-in-to-RDD/m-p/166318#M53812 <P>How can I load a complete table to an RDD using Spark.</P> Wed, 08 Feb 2017 22:59:48 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-MYSQL-table-in-to-RDD/m-p/166318#M53812 das_dineshk 2017-02-08T22:59:48Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-MYSQL-table-in-to-RDD/m-p/166319#M53813 <P>I'm not aware of direct connector to MySQL. You could use Sqoop to ingest the contents of your table into HDFS then use the SparkContext's textFile() method to load it as an RDD.</P> Thu, 09 Feb 2017 00:06:45 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-MYSQL-table-in-to-RDD/m-p/166319#M53813 LesterMartin 2017-02-09T00:06:45Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-MYSQL-table-in-to-RDD/m-p/166320#M53814 <P>There is a JDBC RDD function:</P><PRE>newJdbcRDD(sc: SparkContext, getConnection: () ⇒ Connection, sql: String, lowerBound: Long, upperBound: Long, numPartitions: Int, mapRow: (ResultSet) ⇒ T = JdbcRDD.resultSetToObjectArray)(implicit arg0: ClassTag[T])</PRE> Thu, 09 Feb 2017 00:48:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-MYSQL-table-in-to-RDD/m-p/166320#M53814 jwiden 2017-02-09T00:48:23Z