Hey all,
Has anyone else also found the coalesce function to be prone to some weird
behaviours?
e.g.1: Giving null when it shouldn’t.
e.g.2: I had to change a coalesce(v1,v2,v3) to coalesce(v1,v2,v3,null) (???)
otherwise the query would crash!
Regards,
João Alves
> On 03 Jun 2015, at
presenting any results.
You can explore more possibilities with analytical and windowing functions
here:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics
Best,
João Alves
On 14 Oct 2014, at 14:47, Meri-Tuulia Rautavuori
wrote:
> Hi,
>
> Could you pleas
Hey Anusha,
You sure about that?
The following works for me:
set hive.execution.engine=tez;
select A from table1 UNION ALL select A from table2;
Best,
João
On 03 Oct 2014, at 17:01, anusha Mangina wrote:
> Its fixed.
>
> Union all is not yet supported on Tez
>
> Thanks
>
> On Fri, Oct 3