What does your table definition look like? You should be able to replace 'quarter' with the real column name, and then try executing the query.
On Jan 10, 2012, at 2:01 AM, "Bhavesh Shah" <bhavesh25s...@gmail.com<mailto:bhavesh25s...@gmail.com>> wrote: 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 <aniket...@gmail.com<mailto:aniket...@gmail.com>> wrote: select quarter, COUNT(*) from table group by quarter? On Mon, Jan 9, 2012 at 10:06 PM, Bhavesh Shah <bhavesh25s...@gmail.com<mailto: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" -- Regards, Bhavesh Shah
