Hi,
I'm using hive 2.3.0, spark 2.1.1, and zeppelin 0.7.2.
When I submit query in hive interpreter, it works fine.
I could see exactly same query in zeppelin notebook and hiveserver2 web UI.
However, when I submitted query using sparksql, query seemed wrong.
For example, every columns
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
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
Hi Shahab,
Can you try to use HiveContext? Its should work in 1.1. For SQLContext,
this issues was not fixed in 1.1 and you need to use master branch at the
moment.
Thanks,
Yin
On Sun, Oct 12, 2014 at 5:20 PM, shahab shahab.mok...@gmail.com wrote:
Hi,
Apparently is it is possible to query
Thanks Yin. I trued HiveQL and and it solved that problem. But now I have
second query requirement :
But since you are main developer behind JSON-Spark integration (I saw your
presentation on youtube Easy JSON Data Manipulation in Spark), is it
possible to perform aggregation kind queries,
for
Hi Shahab,
Do you mean queries with group by and aggregation functions? Once you
register the json dataset as a table, you can write queries like querying a
regular table. You can join it with other tables and do aggregations. Is it
what you were asking for? If not, can you give me a more
Hi,
Apparently is it is possible to query nested json using spark SQL, but ,
mainly due to lack of proper documentation/examples, I did not manage to
make it working. I do appreciate if you could point me to any example or
help with this issue,
Here is my code:
val anotherPeopleRDD =