Hive script to create an internal table and insert hourly data aggregated at the daily level.

aggregate_daily.hql

DROP TABLE IF EXISTS milimetric_pagecounts_daily;
CREATE TABLE IF NOT EXISTS milimetric_pagecounts_daily(
  project string,
  page string,
  views int,
  bytes int,
  year int,
  month int,
  day int
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ' '
LOCATION '/user/milimetric/pagecounts_daily'
;

 INSERT INTO TABLE milimetric_pagecounts_daily
 SELECT project,
        page,
        sum(views),
        sum(bytes),
        year,
        month,
        day
   FROM milimetric_pagecounts
  WHERE year = 2013
  GROUP BY project, page, year, month, day
;