Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/page_path_level.sql

Created August 26, 2016 04:14
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/20631934fc7ce02c393bab3dc99a5a1f to your computer and use it in GitHub Desktop.
Save doryokujin/20631934fc7ce02c393bab3dc99a5a1f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
page_path_level.sql
+---------------------------+----------------------------------------------------+-----------------------------+-------------------------+-------------------------+-------------------------+----------------+----------------+
| date_hour:timestamp | page_path:string | page_path_level1:string | page_path_level2:string | page_path_level3:string | page_path_level4:string | pageviews:long | view_id:string |
+---------------------------+----------------------------------------------------+-----------------------------+-------------------------+-------------------------+-------------------------+----------------+----------------+
| "2016-08-18 07:00:00 UTC" | "auth.treasuredata.com/users/password/new" | "auth.treasuredata.com/" | "/users/" | "/password/" | "/new" | 4 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/archive/category/query" | "blog-jp.treasuredata.com/" | "/archive/" | "/category/" | "/query" | 1 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/archive/category/path" | "blog-jp.treasuredata.com/" | "/archive/" | "/category/" | "/path" | 2 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/entry/2012/07/23/000000" | "blog-jp.treasuredata.com/" | "/entry/" | "/2012/" | "/07/23/000000" | 1 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/entry/2014/07/10/150250" | "blog-jp.treasuredata.com/" | "/entry/" | "/2014/" | "/07/10/150250" | 1 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/entry/2014/11/29/165415" | "blog-jp.treasuredata.com/" | "/entry/" | "/2014/" | "/11/29/165415" | 1 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/entry/2014/12/02/120951" | "blog-jp.treasuredata.com/" | "/entry/" | "/2014/" | "/12/02/120951" | 5 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/entry/2014/12/05/122831" | "blog-jp.treasuredata.com/" | "/entry/" | "/2014/" | "/12/05/122831" | 2 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/entry/2014/12/09/101147" | "blog-jp.treasuredata.com/" | "/entry/" | "/2014/" | "/12/09/101147" | 2 | "104634715" |
| "2016-08-18 07:00:00 UTC" | "blog-jp.treasuredata.com/entry/2014/12/12/143412" | "blog-jp.treasuredata.com/" | "/entry/" | "/2014/" | "/12/12/143412" | 3 | "104634715" |
+---------------------------+----------------------------------------------------+-----------------------------+-------------------------+-------------------------+-------------------------+----------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment