OVER is documented here: Windowing and Analytics Functions<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics> .
-- Lefty On Wed, Jan 29, 2014 at 3:41 AM, Andre Araujo <[email protected]> wrote: > The first is available in Hive since early versions (in versions older > than 0.6.0, though, use COUNT(1) instead). > The second is available in Hive starting in version 0.11.0. > > > On 29 January 2014 21:41, unmesha sreeveni <[email protected]> wrote: > >> In SQL we have partion by and group by >> >> select deptno, count(*) c from emp group by deptno; >> >> DEPTNO C >> ------ - >> 10 3 >> 20 5 >> 30 6 >> >> select deptno, count(*) over (partition by deptno) c from emp; >> >> >> DEPTNO C >> ------ - >> 10 3 >> 10 3 >> 10 3 >> 20 5 >> 20 5 >> 20 5 >> 20 5 >> 20 5 >> 30 6 >> 30 6 >> 30 6 >> 30 6 >> 30 6 >> 30 6 >> If we need to practice the same thing in HIVE what will be the option . >> Do we have the same in Hive? >> Pls suggest >> >> Thanks in Advance. >> >> -- >> *Thanks & Regards* >> >> Unmesha Sreeveni U.B >> Junior Developer >> >> http://www.unmeshasreeveni.blogspot.in/ >> >> >> > > > -- > André Araújo > Big Data Consultant/Solutions Architect > The Pythian Group - Australia - www.pythian.com > > Office (calls from within Australia): 1300 366 021 x1270 > Office (international): +61 2 8016 7000 x270 *OR* +1 613 565 8696 x1270 > Mobile: +61 410 323 559 > Fax: +61 2 9805 0544 > IM: pythianaraujo @ AIM/MSN/Y! or [email protected] @ GTalk > > "Success is not about standing at the top, it's the steps you leave behind." > -- Iker Pou (rock climber) > > -- > > > >
