4ndEAtgc

1SELECT HOUR(Time), COUNT(HOUR(Time))
2FROM cloudfront_logs 
3WHERE DateLog BETWEEN '2014-07-05' AND '2014-08-05' 
4GROUP BY HOUR(Time);
5	
614 2000       (2000 requests during 2-3pm)
715 998        (998 requests during 3-4pm)
820 1998       (1998 requests during 8-9pm)
9	
10CREATE EXTERNAL TABLE IF NOT EXISTS cloudfront_logs (
11  DateLog DATE,
12  Time STRING,
13  Location STRING,
14  Bytes INT,
15  RequestIP STRING,
16  Method STRING,
17  Host STRING,
18  Uri STRING,
19  Status INT,
20  Referrer STRING,
21  OS STRING,
22  Browser STRING,
23  BrowserVersion STRING