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....@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