How to get 2 years prior date from currentdate using Spark Sql

I need to derive 2 years prior date of current date using a query in Spark Sql. For ex : today's date is 2016-09-07. I need to get the date exactly 2 years before this date in the above format (-MM-DD). Please let me know if there are multiple approaches and which one would be better. Thanks

Re: Update Data in mySql using spark

I want to update specific data in mySql Table from Spark data-frames or RDD. for example i have column Name ID Farman 1 Ali 2 now i want to update name where id=1.How can I update this specific record. how it is possible in Spark? -- View this message in context:

Re: Update Data in mySql using spark

I want to update specific data in mySql Table from Spark data-frames or RDD. for example i have column Name ID Farman 1 Ali 2 now i want to update name where id=1.How can I update this specific record. how it is possible in Spark? On Sun, Sep 4, 2016 at 11:40 PM, dsorvisto