valid HiveQLs on TreasureData.

access.sql

--  Schema: (
--    path:string
--    method:string
--    ip:string
--    agent:string
--    referer:string
--  )

-- count access per day
SELECT to_date(from_unixtime(time)) AS day, COUNT(*) AS cnt FROM access GROUP BY to_date(from_unixtime(time)) ORDER BY day ASC

-- referer
SELECT referer, COUNT(*) AS cnt FROM access GROUP BY referer ORDER BY referer