{"action":"created","comment":{"url":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/comments/65984205","id":65984205,"diff_hunk":"@@ -557,7 +556,7 @@ If you want InfluxDB to automatically query and downsample all future data see [\n \n Calculate the average `water_level` in `santa_monica`, and write the results to a new measurement (`average`) in the same database:\n ```sql\n-> SELECT mean(water_level) INTO average FROM h2o_feet WHERE location = 'santa_monica' AND time >= '2015-08-18T00:00:00Z' AND time <= '2015-08-18T00:30:00Z' GROUP BY time(12m)\n+> SELECT mean(\"water_level\") INTO \"average\" FROM \"h2o_feet\" WHERE \"location\" = 'santa_monica' AND time >= '2015-08-18T00:00:00Z' AND time <= '2015-08-18T00:30:00Z' GROUP BY time(12m)","path":"content/influxdb/v1.0/query_language/data_exploration.md","position":null,"original_position":243,"commit_id":"1da1799021df19308ad898036779de686cabdc12","original_commit_id":"fe2914116ad3f93daeb1d49218e7717bc280292b","user":{"login":"mjdesa","id":1477539,"avatar_url":"https://avatars.githubusercontent.com/u/1477539?v=3","gravatar_id":"","url":"https://api.github.com/users/mjdesa","html_url":"https://github.com/mjdesa","followers_url":"https://api.github.com/users/mjdesa/followers","following_url":"https://api.github.com/users/mjdesa/following{/other_user}","gists_url":"https://api.github.com/users/mjdesa/gists{/gist_id}","starred_url":"https://api.github.com/users/mjdesa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mjdesa/subscriptions","organizations_url":"https://api.github.com/users/mjdesa/orgs","repos_url":"https://api.github.com/users/mjdesa/repos","events_url":"https://api.github.com/users/mjdesa/events{/privacy}","received_events_url":"https://api.github.com/users/mjdesa/received_events","type":"User","site_admin":false},"body":"`MEAN`","created_at":"2016-06-06T22:54:23Z","updated_at":"2016-06-06T22:54:23Z","html_url":"https://github.com/influxdata/docs.influxdata.com/pull/488#discussion_r65984205","pull_request_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/488","_links":{"self":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/comments/65984205"},"html":{"href":"https://github.com/influxdata/docs.influxdata.com/pull/488#discussion_r65984205"},"pull_request":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/488"}}},"pull_request":{"url":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/488","id":72385964,"html_url":"https://github.com/influxdata/docs.influxdata.com/pull/488","diff_url":"https://github.com/influxdata/docs.influxdata.com/pull/488.diff","patch_url":"https://github.com/influxdata/docs.influxdata.com/pull/488.patch","issue_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues/488","number":488,"state":"open","locked":false,"title":"Docs 1.0","user":{"login":"rkuchan","id":8750814,"avatar_url":"https://avatars.githubusercontent.com/u/8750814?v=3","gravatar_id":"","url":"https://api.github.com/users/rkuchan","html_url":"https://github.com/rkuchan","followers_url":"https://api.github.com/users/rkuchan/followers","following_url":"https://api.github.com/users/rkuchan/following{/other_user}","gists_url":"https://api.github.com/users/rkuchan/gists{/gist_id}","starred_url":"https://api.github.com/users/rkuchan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rkuchan/subscriptions","organizations_url":"https://api.github.com/users/rkuchan/orgs","repos_url":"https://api.github.com/users/rkuchan/repos","events_url":"https://api.github.com/users/rkuchan/events{/privacy}","received_events_url":"https://api.github.com/users/rkuchan/received_events","type":"User","site_admin":false},"body":"### Fixes:\r\n\r\n* https://github.com/influxdata/docs.influxdata.com/issues/434 (Quote identifiers)\r\n* https://github.com/influxdata/docs.influxdata.com/issues/433 (SHOW FIELD KEYS output)\r\n* https://github.com/influxdata/docs.influxdata.com/issues/474 (Ports page in admin section)\r\n* https://github.com/influxdata/docs.influxdata.com/issues/458 (Document `https-private-key` config option)\r\n* https://github.com/influxdata/docs.influxdata.com/issues/482 (Documents the new `::` syntax - see below for more details on this commit)\r\n* https://github.com/influxdata/docs.influxdata.com/issues/459 (`HOLT_WINTERS()` function)\r\n* https://github.com/influxdata/docs.influxdata.com/issues/489 (Updates the config doc, the differences docs, and the upgrading doc)\r\n\r\nAlso adds Chronograf 1.0 docs and Telegraf 1.0 docs.\r\n\r\n### Commit-specific information:\r\n\r\nThe commit `Add description of :: syntax`:\r\n* Removes outdated talk about identical field keys and tag keys being unqueriable\r\n* Adds a description of `<identifier>:tag` and `<identifier>:field` to Data Exploration\r\n* Adds a description of cast operations, that is, `<field_key>:float`, `<field_key>:integer` to Data Exploration\r\n* Adds an FAQ about how `SELECT *` handles field value type discrepancies across shards\r\n\r\nThe commit `Make 0.13 the default version and reword warning on 1.0-beta docs`:\r\n* Makes 0.13 the default version of the docs\r\n* Rewords the note on the 1.0-beta docs to:\r\n```\r\nWarning! This page documents <Product> version 1.0-beta. <Product> v0.13 is the most recent stable version of <Product>.\r\n```\r\nTODOs: \r\n* [ ] Test out the 1.0 to 0.13 redirects for Kapacitor once that gets merged in.\r\n* [x] Mention the autogen and new RP config option in differences doc\r\n* [ ] Update `HOLT_WINTERS()` docs","created_at":"2016-06-02T17:30:07Z","updated_at":"2016-06-06T22:54:23Z","closed_at":null,"merged_at":null,"merge_commit_sha":"32173dad83833eb50f644023c7eef3df8aebdcf7","assignee":null,"milestone":{"url":"https://api.github.com/repos/influxdata/docs.influxdata.com/milestones/5","html_url":"https://github.com/influxdata/docs.influxdata.com/milestones/1.0","labels_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/milestones/5/labels","id":1737496,"number":5,"title":"1.0","description":"","creator":{"login":"beckettsean","id":6537329,"avatar_url":"https://avatars.githubusercontent.com/u/6537329?v=3","gravatar_id":"","url":"https://api.github.com/users/beckettsean","html_url":"https://github.com/beckettsean","followers_url":"https://api.github.com/users/beckettsean/followers","following_url":"https://api.github.com/users/beckettsean/following{/other_user}","gists_url":"https://api.github.com/users/beckettsean/gists{/gist_id}","starred_url":"https://api.github.com/users/beckettsean/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beckettsean/subscriptions","organizations_url":"https://api.github.com/users/beckettsean/orgs","repos_url":"https://api.github.com/users/beckettsean/repos","events_url":"https://api.github.com/users/beckettsean/events{/privacy}","received_events_url":"https://api.github.com/users/beckettsean/received_events","type":"User","site_admin":false},"open_issues":21,"closed_issues":4,"state":"open","created_at":"2016-04-28T21:46:22Z","updated_at":"2016-06-06T20:38:52Z","due_on":null,"closed_at":null},"commits_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/488/commits","review_comments_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/488/comments","review_comment_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/comments{/number}","comments_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues/488/comments","statuses_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/statuses/1da1799021df19308ad898036779de686cabdc12","head":{"label":"influxdata:docs-1.0","ref":"docs-1.0","sha":"1da1799021df19308ad898036779de686cabdc12","user":{"login":"influxdata","id":5713248,"avatar_url":"https://avatars.githubusercontent.com/u/5713248?v=3","gravatar_id":"","url":"https://api.github.com/users/influxdata","html_url":"https://github.com/influxdata","followers_url":"https://api.github.com/users/influxdata/followers","following_url":"https://api.github.com/users/influxdata/following{/other_user}","gists_url":"https://api.github.com/users/influxdata/gists{/gist_id}","starred_url":"https://api.github.com/users/influxdata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/influxdata/subscriptions","organizations_url":"https://api.github.com/users/influxdata/orgs","repos_url":"https://api.github.com/users/influxdata/repos","events_url":"https://api.github.com/users/influxdata/events{/privacy}","received_events_url":"https://api.github.com/users/influxdata/received_events","type":"Organization","site_admin":false},"repo":{"id":42206749,"name":"docs.influxdata.com","full_name":"influxdata/docs.influxdata.com","owner":{"login":"influxdata","id":5713248,"avatar_url":"https://avatars.githubusercontent.com/u/5713248?v=3","gravatar_id":"","url":"https://api.github.com/users/influxdata","html_url":"https://github.com/influxdata","followers_url":"https://api.github.com/users/influxdata/followers","following_url":"https://api.github.com/users/influxdata/following{/other_user}","gists_url":"https://api.github.com/users/influxdata/gists{/gist_id}","starred_url":"https://api.github.com/users/influxdata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/influxdata/subscriptions","organizations_url":"https://api.github.com/users/influxdata/orgs","repos_url":"https://api.github.com/users/influxdata/repos","events_url":"https://api.github.com/users/influxdata/events{/privacy}","received_events_url":"https://api.github.com/users/influxdata/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/influxdata/docs.influxdata.com","description":"New docs for InfluxData","fork":false,"url":"https://api.github.com/repos/influxdata/docs.influxdata.com","forks_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/forks","keys_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/keys{/key_id}","collaborators_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/teams","hooks_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/hooks","issue_events_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues/events{/number}","events_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/events","assignees_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/assignees{/user}","branches_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/branches{/branch}","tags_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/tags","blobs_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/refs{/sha}","trees_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/trees{/sha}","statuses_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/statuses/{sha}","languages_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/languages","stargazers_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/stargazers","contributors_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/contributors","subscribers_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/subscribers","subscription_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/subscription","commits_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/commits{/sha}","git_commits_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/commits{/sha}","comments_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/comments{/number}","issue_comment_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues/comments{/number}","contents_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/contents/{+path}","compare_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/compare/{base}...{head}","merges_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/merges","archive_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/downloads","issues_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues{/number}","pulls_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls{/number}","milestones_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/milestones{/number}","notifications_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/labels{/name}","releases_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/releases{/id}","deployments_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/deployments","created_at":"2015-09-09T21:50:49Z","updated_at":"2016-05-28T16:23:39Z","pushed_at":"2016-06-06T22:53:49Z","git_url":"git://github.com/influxdata/docs.influxdata.com.git","ssh_url":"git@github.com:influxdata/docs.influxdata.com.git","clone_url":"https://github.com/influxdata/docs.influxdata.com.git","svn_url":"https://github.com/influxdata/docs.influxdata.com","homepage":"https://docs.influxdata.com/","size":22895,"stargazers_count":15,"watchers_count":15,"language":"CSS","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":56,"mirror_url":null,"open_issues_count":44,"forks":56,"open_issues":44,"watchers":15,"default_branch":"master"}},"base":{"label":"influxdata:master","ref":"master","sha":"dc88635cad9fba0e676c8809bc3c3ff632db596f","user":{"login":"influxdata","id":5713248,"avatar_url":"https://avatars.githubusercontent.com/u/5713248?v=3","gravatar_id":"","url":"https://api.github.com/users/influxdata","html_url":"https://github.com/influxdata","followers_url":"https://api.github.com/users/influxdata/followers","following_url":"https://api.github.com/users/influxdata/following{/other_user}","gists_url":"https://api.github.com/users/influxdata/gists{/gist_id}","starred_url":"https://api.github.com/users/influxdata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/influxdata/subscriptions","organizations_url":"https://api.github.com/users/influxdata/orgs","repos_url":"https://api.github.com/users/influxdata/repos","events_url":"https://api.github.com/users/influxdata/events{/privacy}","received_events_url":"https://api.github.com/users/influxdata/received_events","type":"Organization","site_admin":false},"repo":{"id":42206749,"name":"docs.influxdata.com","full_name":"influxdata/docs.influxdata.com","owner":{"login":"influxdata","id":5713248,"avatar_url":"https://avatars.githubusercontent.com/u/5713248?v=3","gravatar_id":"","url":"https://api.github.com/users/influxdata","html_url":"https://github.com/influxdata","followers_url":"https://api.github.com/users/influxdata/followers","following_url":"https://api.github.com/users/influxdata/following{/other_user}","gists_url":"https://api.github.com/users/influxdata/gists{/gist_id}","starred_url":"https://api.github.com/users/influxdata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/influxdata/subscriptions","organizations_url":"https://api.github.com/users/influxdata/orgs","repos_url":"https://api.github.com/users/influxdata/repos","events_url":"https://api.github.com/users/influxdata/events{/privacy}","received_events_url":"https://api.github.com/users/influxdata/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/influxdata/docs.influxdata.com","description":"New docs for InfluxData","fork":false,"url":"https://api.github.com/repos/influxdata/docs.influxdata.com","forks_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/forks","keys_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/keys{/key_id}","collaborators_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/teams","hooks_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/hooks","issue_events_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues/events{/number}","events_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/events","assignees_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/assignees{/user}","branches_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/branches{/branch}","tags_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/tags","blobs_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/refs{/sha}","trees_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/trees{/sha}","statuses_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/statuses/{sha}","languages_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/languages","stargazers_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/stargazers","contributors_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/contributors","subscribers_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/subscribers","subscription_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/subscription","commits_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/commits{/sha}","git_commits_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/git/commits{/sha}","comments_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/comments{/number}","issue_comment_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues/comments{/number}","contents_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/contents/{+path}","compare_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/compare/{base}...{head}","merges_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/merges","archive_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/downloads","issues_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues{/number}","pulls_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls{/number}","milestones_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/milestones{/number}","notifications_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/labels{/name}","releases_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/releases{/id}","deployments_url":"https://api.github.com/repos/influxdata/docs.influxdata.com/deployments","created_at":"2015-09-09T21:50:49Z","updated_at":"2016-05-28T16:23:39Z","pushed_at":"2016-06-06T22:53:49Z","git_url":"git://github.com/influxdata/docs.influxdata.com.git","ssh_url":"git@github.com:influxdata/docs.influxdata.com.git","clone_url":"https://github.com/influxdata/docs.influxdata.com.git","svn_url":"https://github.com/influxdata/docs.influxdata.com","homepage":"https://docs.influxdata.com/","size":22895,"stargazers_count":15,"watchers_count":15,"language":"CSS","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":56,"mirror_url":null,"open_issues_count":44,"forks":56,"open_issues":44,"watchers":15,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/488"},"html":{"href":"https://github.com/influxdata/docs.influxdata.com/pull/488"},"issue":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues/488"},"comments":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/issues/488/comments"},"review_comments":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/488/comments"},"review_comment":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/pulls/488/commits"},"statuses":{"href":"https://api.github.com/repos/influxdata/docs.influxdata.com/statuses/1da1799021df19308ad898036779de686cabdc12"}}}}
{"actor":{"display_login":"mjdesa"}}