select quarter, COUNT(*) from table group by quarter? On Mon, Jan 9, 2012 at 10:06 PM, Bhavesh Shah <bhavesh25s...@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"