hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Petter von Dolwitz (Hem)" <>
Subject Re: Help with Query
Date Sat, 31 May 2014 23:02:31 GMT
SELECT COUNT(DISTINCT ip) AS count, query_string
FROM myTable
GROUP BY query_string

This should give you one row per asked query. Rows are ordered by nummer of
unique IPs that asked the query. Most popular first.

Den 30 maj 2014 19:17 skrev "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

View raw message