RE: standalone to connect mysql

2015-07-21 Thread Jack Yang
: sqlContext.sql(sinsert into Table newStu select * from otherStu) that works. Is there any document addressing that? Best regards, Jack From: Terry Hole [mailto:hujie.ea...@gmail.com] Sent: Tuesday, 21 July 2015 4:17 PM To: Jack Yang; user@spark.apache.org Subject: Re: standalone to connect mysql

Re: standalone to connect mysql

2015-07-21 Thread Terry Hole
that? Best regards, Jack *From:* Terry Hole [mailto:hujie.ea...@gmail.com] *Sent:* Tuesday, 21 July 2015 4:17 PM *To:* Jack Yang; user@spark.apache.org *Subject:* Re: standalone to connect mysql Maybe you can try: spark-submit --class sparkwithscala.SqlApp --jars /home/lib/mysql-connector

Re: standalone to connect mysql

2015-07-21 Thread Jack Yang
[mailto:hujie.ea...@gmail.commailto:hujie.ea...@gmail.com] Sent: Tuesday, 21 July 2015 4:17 PM To: Jack Yang; user@spark.apache.orgmailto:user@spark.apache.org Subject: Re: standalone to connect mysql Maybe you can try: spark-submit --class sparkwithscala.SqlApp --jars /home/lib/mysql-connector-java-5.1.34.jar

Re: standalone to connect mysql

2015-07-21 Thread Jack Yang
July 2015 4:17 PM To: Jack Yang; user@spark.apache.orgmailto:user@spark.apache.org Subject: Re: standalone to connect mysql Maybe you can try: spark-submit --class sparkwithscala.SqlApp --jars /home/lib/mysql-connector-java-5.1.34.jar --master spark://hadoop1:7077 /home/myjar.jar Thanks! -Terry Hi

Re: standalone to connect mysql

2015-07-21 Thread Terry Hole
Maybe you can try: spark-submit --class sparkwithscala.SqlApp --jars /home/lib/mysql-connector-java-5.1.34.jar --master spark://hadoop1:7077 /home/myjar.jar Thanks! -Terry Hi there, I would like to use spark to access the data in mysql. So firstly I tried to run the program using:

standalone to connect mysql

2015-07-20 Thread Jack Yang
Hi there, I would like to use spark to access the data in mysql. So firstly I tried to run the program using: spark-submit --class sparkwithscala.SqlApp --driver-class-path /home/lib/mysql-connector-java-5.1.34.jar --master local[4] /home/myjar.jar that returns me the correct results. Then I