I tried to answer this earlier. Maybe the mail got suck somewhere. I'll try again.
SELECT COUNT(DISTINCT ip) AS count, query_string FROM myTable GROUP BY query_string ORDER BY count DESC; This should give you one row per asked query. Rows are ordered by number of unique IPs that asked the query. Most popular first. Br, Petter 2014-05-30 1:29 GMT+02:00 Software Dev <static.void....@gmail.com>: > 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 >
