hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aniket Mokashi <aniket...@gmail.com>
Subject Re: How to calculate count of quarter wise record in Hive?
Date Tue, 10 Jan 2012 06:34:45 GMT
select quarter, COUNT(*) from table group by quarter?

On Mon, Jan 9, 2012 at 10:06 PM, Bhavesh Shah <bhavesh25shah@gmail.com>wrote:

> Hello,
> I want to calculate count of quarter wise record in Hive.
> (e.g.: In 1st Quarter - 72 (counts) likewise for other quarter)
>
> How can we calculate it through query or UDF in Hive?
>
> --
> Thanks and Regards,
> Bhavesh Shah
>



-- 
"...:::Aniket:::... Quetzalco@tl"

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message