hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: Help with query
Date Wed, 04 Jun 2014 06:46:06 GMT
can you put your example with sample data and expected result output?


On Fri, May 30, 2014 at 4:59 AM, Software Dev <static.void.dev@gmail.com>
wrote:

> We have a table with user entered queries, their IP. How could we
> write a query that will count and order queries by their count having
> a unique IP count > X. For example if we had the same IP enter the
> same query Y times we wouldnlt want to include this in the final
> result unless there have been X-Y other IP's that searched for that
> query.
>
> Is this perhaps better suited fro Pig?
>
> Thanks
>



-- 
Nitin Pawar

Mime
View raw message