Hi Neeraj, As per my understanding Spark SQL doesn't support Update statements . Why you need update command in Spark SQL, You can run command in Hive .
Regards, Vaquar khan On Mon, Dec 12, 2016 at 10:21 PM, Niraj Kumar <nku...@incedoinc.com> wrote: > Hi > > > > I am working on SpqrkSQL using hiveContext (version 1.6.2). > > Can I run following queries directly in sparkSQL, if yes how > > > > update calls set sample = 'Y' where accnt_call_id in (select accnt_call_id > from samples); > > > > insert into details (accnt_call_id, prdct_cd, prdct_id, dtl_pstn) select > accnt_call_id, prdct_cd, prdct_id, 32 from samples where PRDCT_CD = 2114515; > > > > > > > > Thanks and Regards, > > *Niraj Kumar* > > > > Disclaimer : > This email communication may contain privileged and confidential > information and is intended for the use of the addressee only. If you are > not an intended recipient you are requested not to reproduce, copy > disseminate or in any manner distribute this email communication as the > same is strictly prohibited. If you have received this email in error, > please notify the sender immediately by return e-mail and delete the > communication sent in error. Email communications cannot be guaranteed to > be secure & error free and Incedo Inc. is not liable for any errors in > the email communication or for the proper, timely and complete transmission > thereof. > -- Regards, Vaquar Khan +1 -224-436-0783 IT Architect / Lead Consultant Greater Chicago