You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by Niraj Kumar <nk...@incedoinc.com> on 2016/12/13 04:21:04 UTC
Query in SparkSQL
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.
Re: Query in SparkSQL
Posted by vaquar khan <va...@gmail.com>.
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 <nk...@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