Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/a.sql

Created August 26, 2016 06:37
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/7cd36f72d822bc12acd6e9f7ee7fda72 to your computer and use it in GitHub Desktop.
Save doryokujin/7cd36f72d822bc12acd6e9f7ee7fda72 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
a.sql
+---------------------------+------------------------------+-------------------------+-------------------+----------------+----------------+---------------------------+
| date_hour:timestamp | page_path:string | dimension1:string | dimension2:string | pageviews:long | view_id:string | time2:timestamp |
+---------------------------+------------------------------+-------------------------+-------------------+----------------+----------------+---------------------------+
| "2016-08-22 02:00:00 UTC" | "/" | "1646047626.1464089685" | "1471831722644" | 1 | "128049838" | "1927-06-22 21:35:16 UTC" |
| "2016-08-22 02:00:00 UTC" | "/entry/20101102/1288651712" | "1192170867.1468485627" | "1471833441226" | 1 | "128049838" | "1927-07-12 18:58:18 UTC" |
| "2016-08-22 02:00:00 UTC" | "/entry/20101116/1289860948" | "781104774.1469012530" | "1471833732132" | 1 | "128049838" | "1927-07-16 03:46:44 UTC" |
| "2016-08-22 02:00:00 UTC" | "/entry/2014/02/04/145027" | "318470974.1463383543" | "1471833680773" | 1 | "128049838" | "1927-07-15 13:30:45 UTC" |
| "2016-08-22 02:00:00 UTC" | "/entry/2014/02/06/000000" | "1806353841.1468204754" | "1471834643740" | 1 | "128049838" | "1927-07-26 17:00:12 UTC" |
| "2016-08-22 03:00:00 UTC" | "/entry/20110519/1305737343" | "1172146118.1465981404" | "1471837839038" | 1 | "128049838" | "1927-09-01 16:35:10 UTC" |
| "2016-08-22 03:00:00 UTC" | "/entry/2012/07/13/041634" | "1493588479.1465341805" | "1471836723560" | 1 | "128049838" | "1927-08-19 18:43:52 UTC" |
| "2016-08-22 03:00:00 UTC" | "/entry/2016/01/09/211747" | "1174883870.1465729768" | "1471837531700" | 1 | "128049838" | "1927-08-29 03:12:52 UTC" |
| "2016-08-22 04:00:00 UTC" | "/entry/20110614/1308010072" | "2017183738.1421123733" | "1471839860050" | 1 | "128049838" | "1927-09-25 01:58:42 UTC" |
| "2016-08-22 04:00:00 UTC" | "/entry/2014/01/14/175541" | "225366604.1460689763" | "1471841160760" | 1 | "128049838" | "1927-10-10 03:17:12 UTC" |
+---------------------------+------------------------------+-------------------------+-------------------+----------------+----------------+---------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment