Skip to content

Instantly share code, notes, and snippets.

@doryokujin
Last active August 25, 2016 04:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doryokujin/84579fcee6fa0ea84226a756712b1b34 to your computer and use it in GitHub Desktop.
Save doryokujin/84579fcee6fa0ea84226a756712b1b34 to your computer and use it in GitHub Desktop.
+---------------------------+-------------+-------------+--------------+------------+-------------+----------------+
| date_hour:timestamp | date:string | year:string | month:string | day:string | hour:string | pageviews:long |
+---------------------------+-------------+-------------+--------------+------------+-------------+----------------+
| "2016-08-17 15:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "00" | 8 |
| "2016-08-17 16:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "01" | 13 |
| "2016-08-17 17:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "02" | 9 |
| "2016-08-17 18:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "03" | 11 |
| "2016-08-17 20:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "05" | 24 |
| "2016-08-17 21:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "06" | 7 |
| "2016-08-17 22:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "07" | 7 |
| "2016-08-17 23:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "08" | 34 |
| "2016-08-18 00:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "09" | 72 |
| "2016-08-18 01:00:00 UTC" | "20160818" | "2016" | "08" | "18" | "10" | 72 |
+---------------------------+-------------+-------------+--------------+------------+-------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment