hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <>
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 <>

> 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

View raw message