Re: Query in SparkSQL

2016-12-12 Thread vaquar khan
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 wrote: > Hi > > > > I am working on SpqrkSQL using hiveContext (version 1.

Query in SparkSQL

2016-12-12 Thread Niraj Kumar
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_c