Re: Spark code to write to MySQL and Hive

2018-08-29 Thread Jacek Laskowski
null| > > +---+--+-+ > > > > +---+--+-+ > > | id| country| city| > > +---+--+-+ > > | 11| USA|Palo Alto| > > | 12|Czech Republic| Brno| > > | 13| USA|Sunnyvale

RE: Spark code to write to MySQL and Hive

2018-08-29 Thread ryandam.9
From: ryanda...@gmail.com Sent: Wednesday, August 29, 2018 8:19 PM To: user@spark.apache.org Subject: Spark code to write to MySQL and Hive Hi, Can anyone help me to understand what is happening with my code ? I wrote a Spark application to read from a MySQL table [that already has 4 records]

Spark code to write to MySQL and Hive

2018-08-29 Thread ryandam.9
Hi, Can anyone help me to understand what is happening with my code ? I wrote a Spark application to read from a MySQL table [that already has 4 records], Create a new DF by adding 10 to the ID field. Then, I wanted to write the new DF to MySQL as well as to Hive. I am surprised to se