Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - How to calculate count of quarter wise record in Hive?


Copy link to this message
-
Re: How to calculate count of quarter wise record in Hive?
Aniket Mokashi 2012-01-10, 06:34
select quarter, COUNT(*) from table group by quarter?

On Mon, Jan 9, 2012 at 10:06 PM, Bhavesh Shah <[EMAIL PROTECTED]>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"