Thanks Aniket for the reply. But when I try this I got the error:
hive> select quarter, count(*) from subset group by quarter; FAILED: Error in semantic analysis: Line 1:46 Invalid table alias or column reference quarter Is there any mistake in query. On Tue, Jan 10, 2012 at 12:04 PM, Aniket Mokashi <[email protected]>wrote: > 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" > -- Regards, Bhavesh Shah
