hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bhavesh Shah <bhavesh25s...@gmail.com>
Subject Re: How to calculate count of quarter wise record in Hive?
Date Tue, 10 Jan 2012 07:00:06 GMT
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 <aniket486@gmail.com>wrote:

> 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"
>



-- 
Regards,
Bhavesh Shah

Mime
View raw message