Unique Domain Names queried per Day

Description:

Returns the number of (existing) unique domain names queries on a certain day, for a whole month period.

Note that this can run for a while..

Impala Query:

select day, count(distinct(domainname)) from dns.queries where year=2017 and month=10 and rcode=0 group by day order by day asc;

Example Output:

+-----+------------------------------+
| day | count(distinct (domainname)) |
+-----+------------------------------+
| 1 | 1814935 |
| 2 | 1552925 |
| 3 | 1417084 |
| 4 | 1395547 |
| 5 | 1305477 |
...