Create a gist now

Instantly share code, notes, and snippets.

+---------------------------+-------------+-------------+--------------+------------+-------------+----------------+
| 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