Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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?
I discussed this offline. The problem was --
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-GROUPingandSORTingonf%28column%29

Thanks,
Aniket

On Tue, Jan 10, 2012 at 5:06 AM, Tucker, Matt <[EMAIL PROTECTED]>wrote:

> 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" <[EMAIL PROTECTED]>
> 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 <[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
>
>
--
"...:::Aniket:::... Quetzalco@tl"
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB