Group By and Partion By in Hive

[unmesha sreeveni]

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/