Re: standalone to connect mysql

2015-07-21 Thread Jack Yang
addressing that? Best regards, Jack From: Terry Hole [mailto:hujie.ea...@gmail.com<mailto:hujie.ea...@gmail.com>] Sent: Tuesday, 21 July 2015 4:17 PM To: Jack Yang; user@spark.apache.org<mailto:user@spark.apache.org> Subject: Re: standalone to connect mysql Maybe you can try: spark-submi

Re: standalone to connect mysql

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

Re: standalone to connect mysql

2015-07-21 Thread Terry Hole
t.sql(s"insert 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] > *Sen

RE: standalone to connect mysql

2015-07-21 Thread Jack Yang
27;, aa, 1) but if I did: sqlContext.sql(s"insert 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

Re: standalone to connect mysql

2015-07-20 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