{"action":"created","comment":{"url":"https://api.github.com/repos/yandex/ClickHouse/pulls/comments/270187258","pull_request_review_id":220257160,"id":270187258,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDI3MDE4NzI1OA==","diff_hunk":"@@ -374,10 +381,27 @@ WHERE changed\n \n ## system.tables\n \n-This table contains the String columns 'database', 'name', and 'engine'.\n-The table also contains three virtual columns: metadata_modification_time (DateTime type), create_table_query, and engine_full (String type).\n-Each table that the server knows about is entered in the 'system.tables' table.\n-This system table is used for implementing SHOW TABLES queries.\n+Contains metadata of each table that the server knows about. Detached tables are not shown in `system.table`.","path":"docs/en/operations/system_tables.md","position":44,"original_position":44,"commit_id":"48a672ddbb136be48884c1aab32b5f0467dc245e","original_commit_id":"48a672ddbb136be48884c1aab32b5f0467dc245e","user":{"login":"blinkov","id":623861,"node_id":"MDQ6VXNlcjYyMzg2MQ==","avatar_url":"https://avatars3.githubusercontent.com/u/623861?v=4","gravatar_id":"","url":"https://api.github.com/users/blinkov","html_url":"https://github.com/blinkov","followers_url":"https://api.github.com/users/blinkov/followers","following_url":"https://api.github.com/users/blinkov/following{/other_user}","gists_url":"https://api.github.com/users/blinkov/gists{/gist_id}","starred_url":"https://api.github.com/users/blinkov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blinkov/subscriptions","organizations_url":"https://api.github.com/users/blinkov/orgs","repos_url":"https://api.github.com/users/blinkov/repos","events_url":"https://api.github.com/users/blinkov/events{/privacy}","received_events_url":"https://api.github.com/users/blinkov/received_events","type":"User","site_admin":false},"body":"system.table**s**","created_at":"2019-03-28T20:31:36Z","updated_at":"2019-03-28T20:42:32Z","html_url":"https://github.com/yandex/ClickHouse/pull/4838#discussion_r270187258","pull_request_url":"https://api.github.com/repos/yandex/ClickHouse/pulls/4838","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/comments/270187258"},"html":{"href":"https://github.com/yandex/ClickHouse/pull/4838#discussion_r270187258"},"pull_request":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/4838"}}},"pull_request":{"url":"https://api.github.com/repos/yandex/ClickHouse/pulls/4838","id":265481022,"node_id":"MDExOlB1bGxSZXF1ZXN0MjY1NDgxMDIy","html_url":"https://github.com/yandex/ClickHouse/pull/4838","diff_url":"https://github.com/yandex/ClickHouse/pull/4838.diff","patch_url":"https://github.com/yandex/ClickHouse/pull/4838.patch","issue_url":"https://api.github.com/repos/yandex/ClickHouse/issues/4838","number":4838,"state":"open","locked":false,"title":"Doc fix: Update info about system.columns + system.tables (en)","user":{"login":"ogorbacheva","id":5416616,"node_id":"MDQ6VXNlcjU0MTY2MTY=","avatar_url":"https://avatars0.githubusercontent.com/u/5416616?v=4","gravatar_id":"","url":"https://api.github.com/users/ogorbacheva","html_url":"https://github.com/ogorbacheva","followers_url":"https://api.github.com/users/ogorbacheva/followers","following_url":"https://api.github.com/users/ogorbacheva/following{/other_user}","gists_url":"https://api.github.com/users/ogorbacheva/gists{/gist_id}","starred_url":"https://api.github.com/users/ogorbacheva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ogorbacheva/subscriptions","organizations_url":"https://api.github.com/users/ogorbacheva/orgs","repos_url":"https://api.github.com/users/ogorbacheva/repos","events_url":"https://api.github.com/users/ogorbacheva/events{/privacy}","received_events_url":"https://api.github.com/users/ogorbacheva/received_events","type":"User","site_admin":false},"body":"I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en\r\n\r\nCategory (leave one):\r\n- Doc fix.\r\n","created_at":"2019-03-28T19:55:24Z","updated_at":"2019-03-28T20:42:32Z","closed_at":null,"merged_at":null,"merge_commit_sha":"c16f6d5549061339633ffdec599ebba25cd30e9b","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":785082162,"node_id":"MDU6TGFiZWw3ODUwODIxNjI=","url":"https://api.github.com/repos/yandex/ClickHouse/labels/documentation","name":"documentation","color":"fef2c0","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/yandex/ClickHouse/pulls/4838/commits","review_comments_url":"https://api.github.com/repos/yandex/ClickHouse/pulls/4838/comments","review_comment_url":"https://api.github.com/repos/yandex/ClickHouse/pulls/comments{/number}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/issues/4838/comments","statuses_url":"https://api.github.com/repos/yandex/ClickHouse/statuses/48a672ddbb136be48884c1aab32b5f0467dc245e","head":{"label":"ogorbacheva:DOCAPI-5766-system-tables","ref":"DOCAPI-5766-system-tables","sha":"48a672ddbb136be48884c1aab32b5f0467dc245e","user":{"login":"ogorbacheva","id":5416616,"node_id":"MDQ6VXNlcjU0MTY2MTY=","avatar_url":"https://avatars0.githubusercontent.com/u/5416616?v=4","gravatar_id":"","url":"https://api.github.com/users/ogorbacheva","html_url":"https://github.com/ogorbacheva","followers_url":"https://api.github.com/users/ogorbacheva/followers","following_url":"https://api.github.com/users/ogorbacheva/following{/other_user}","gists_url":"https://api.github.com/users/ogorbacheva/gists{/gist_id}","starred_url":"https://api.github.com/users/ogorbacheva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ogorbacheva/subscriptions","organizations_url":"https://api.github.com/users/ogorbacheva/orgs","repos_url":"https://api.github.com/users/ogorbacheva/repos","events_url":"https://api.github.com/users/ogorbacheva/events{/privacy}","received_events_url":"https://api.github.com/users/ogorbacheva/received_events","type":"User","site_admin":false},"repo":{"id":159798922,"node_id":"MDEwOlJlcG9zaXRvcnkxNTk3OTg5MjI=","name":"ClickHouse","full_name":"ogorbacheva/ClickHouse","private":false,"owner":{"login":"ogorbacheva","id":5416616,"node_id":"MDQ6VXNlcjU0MTY2MTY=","avatar_url":"https://avatars0.githubusercontent.com/u/5416616?v=4","gravatar_id":"","url":"https://api.github.com/users/ogorbacheva","html_url":"https://github.com/ogorbacheva","followers_url":"https://api.github.com/users/ogorbacheva/followers","following_url":"https://api.github.com/users/ogorbacheva/following{/other_user}","gists_url":"https://api.github.com/users/ogorbacheva/gists{/gist_id}","starred_url":"https://api.github.com/users/ogorbacheva/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ogorbacheva/subscriptions","organizations_url":"https://api.github.com/users/ogorbacheva/orgs","repos_url":"https://api.github.com/users/ogorbacheva/repos","events_url":"https://api.github.com/users/ogorbacheva/events{/privacy}","received_events_url":"https://api.github.com/users/ogorbacheva/received_events","type":"User","site_admin":false},"html_url":"https://github.com/ogorbacheva/ClickHouse","description":"ClickHouse is a free analytic DBMS for big data.","fork":true,"url":"https://api.github.com/repos/ogorbacheva/ClickHouse","forks_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/forks","keys_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/teams","hooks_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/hooks","issue_events_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/issues/events{/number}","events_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/events","assignees_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/assignees{/user}","branches_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/branches{/branch}","tags_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/tags","blobs_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/git/refs{/sha}","trees_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/statuses/{sha}","languages_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/languages","stargazers_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/stargazers","contributors_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/contributors","subscribers_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/subscribers","subscription_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/subscription","commits_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/commits{/sha}","git_commits_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/git/commits{/sha}","comments_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/comments{/number}","issue_comment_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/issues/comments{/number}","contents_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/contents/{+path}","compare_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/merges","archive_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/downloads","issues_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/issues{/number}","pulls_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/pulls{/number}","milestones_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/milestones{/number}","notifications_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/labels{/name}","releases_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/releases{/id}","deployments_url":"https://api.github.com/repos/ogorbacheva/ClickHouse/deployments","created_at":"2018-11-30T09:20:37Z","updated_at":"2018-11-30T09:20:48Z","pushed_at":"2019-03-28T19:54:36Z","git_url":"git://github.com/ogorbacheva/ClickHouse.git","ssh_url":"git@github.com:ogorbacheva/ClickHouse.git","clone_url":"https://github.com/ogorbacheva/ClickHouse.git","svn_url":"https://github.com/ogorbacheva/ClickHouse","homepage":"https://clickhouse.yandex","size":113849,"stargazers_count":0,"watchers_count":0,"language":"C++","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":"NOASSERTION","url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"yandex:master","ref":"master","sha":"8f9c8defc568b76a7ee1ec90d6a2e6553ccef66e","user":{"login":"yandex","id":7409213,"node_id":"MDEyOk9yZ2FuaXphdGlvbjc0MDkyMTM=","avatar_url":"https://avatars1.githubusercontent.com/u/7409213?v=4","gravatar_id":"","url":"https://api.github.com/users/yandex","html_url":"https://github.com/yandex","followers_url":"https://api.github.com/users/yandex/followers","following_url":"https://api.github.com/users/yandex/following{/other_user}","gists_url":"https://api.github.com/users/yandex/gists{/gist_id}","starred_url":"https://api.github.com/users/yandex/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yandex/subscriptions","organizations_url":"https://api.github.com/users/yandex/orgs","repos_url":"https://api.github.com/users/yandex/repos","events_url":"https://api.github.com/users/yandex/events{/privacy}","received_events_url":"https://api.github.com/users/yandex/received_events","type":"Organization","site_admin":false},"repo":{"id":60246359,"node_id":"MDEwOlJlcG9zaXRvcnk2MDI0NjM1OQ==","name":"ClickHouse","full_name":"yandex/ClickHouse","private":false,"owner":{"login":"yandex","id":7409213,"node_id":"MDEyOk9yZ2FuaXphdGlvbjc0MDkyMTM=","avatar_url":"https://avatars1.githubusercontent.com/u/7409213?v=4","gravatar_id":"","url":"https://api.github.com/users/yandex","html_url":"https://github.com/yandex","followers_url":"https://api.github.com/users/yandex/followers","following_url":"https://api.github.com/users/yandex/following{/other_user}","gists_url":"https://api.github.com/users/yandex/gists{/gist_id}","starred_url":"https://api.github.com/users/yandex/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yandex/subscriptions","organizations_url":"https://api.github.com/users/yandex/orgs","repos_url":"https://api.github.com/users/yandex/repos","events_url":"https://api.github.com/users/yandex/events{/privacy}","received_events_url":"https://api.github.com/users/yandex/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/yandex/ClickHouse","description":"ClickHouse is a free analytic DBMS for big data.","fork":false,"url":"https://api.github.com/repos/yandex/ClickHouse","forks_url":"https://api.github.com/repos/yandex/ClickHouse/forks","keys_url":"https://api.github.com/repos/yandex/ClickHouse/keys{/key_id}","collaborators_url":"https://api.github.com/repos/yandex/ClickHouse/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/yandex/ClickHouse/teams","hooks_url":"https://api.github.com/repos/yandex/ClickHouse/hooks","issue_events_url":"https://api.github.com/repos/yandex/ClickHouse/issues/events{/number}","events_url":"https://api.github.com/repos/yandex/ClickHouse/events","assignees_url":"https://api.github.com/repos/yandex/ClickHouse/assignees{/user}","branches_url":"https://api.github.com/repos/yandex/ClickHouse/branches{/branch}","tags_url":"https://api.github.com/repos/yandex/ClickHouse/tags","blobs_url":"https://api.github.com/repos/yandex/ClickHouse/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/yandex/ClickHouse/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/yandex/ClickHouse/git/refs{/sha}","trees_url":"https://api.github.com/repos/yandex/ClickHouse/git/trees{/sha}","statuses_url":"https://api.github.com/repos/yandex/ClickHouse/statuses/{sha}","languages_url":"https://api.github.com/repos/yandex/ClickHouse/languages","stargazers_url":"https://api.github.com/repos/yandex/ClickHouse/stargazers","contributors_url":"https://api.github.com/repos/yandex/ClickHouse/contributors","subscribers_url":"https://api.github.com/repos/yandex/ClickHouse/subscribers","subscription_url":"https://api.github.com/repos/yandex/ClickHouse/subscription","commits_url":"https://api.github.com/repos/yandex/ClickHouse/commits{/sha}","git_commits_url":"https://api.github.com/repos/yandex/ClickHouse/git/commits{/sha}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/comments{/number}","issue_comment_url":"https://api.github.com/repos/yandex/ClickHouse/issues/comments{/number}","contents_url":"https://api.github.com/repos/yandex/ClickHouse/contents/{+path}","compare_url":"https://api.github.com/repos/yandex/ClickHouse/compare/{base}...{head}","merges_url":"https://api.github.com/repos/yandex/ClickHouse/merges","archive_url":"https://api.github.com/repos/yandex/ClickHouse/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/yandex/ClickHouse/downloads","issues_url":"https://api.github.com/repos/yandex/ClickHouse/issues{/number}","pulls_url":"https://api.github.com/repos/yandex/ClickHouse/pulls{/number}","milestones_url":"https://api.github.com/repos/yandex/ClickHouse/milestones{/number}","notifications_url":"https://api.github.com/repos/yandex/ClickHouse/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/yandex/ClickHouse/labels{/name}","releases_url":"https://api.github.com/repos/yandex/ClickHouse/releases{/id}","deployments_url":"https://api.github.com/repos/yandex/ClickHouse/deployments","created_at":"2016-06-02T08:28:18Z","updated_at":"2019-03-28T18:22:46Z","pushed_at":"2019-03-28T20:20:43Z","git_url":"git://github.com/yandex/ClickHouse.git","ssh_url":"git@github.com:yandex/ClickHouse.git","clone_url":"https://github.com/yandex/ClickHouse.git","svn_url":"https://github.com/yandex/ClickHouse","homepage":"https://clickhouse.yandex","size":115248,"stargazers_count":6489,"watchers_count":6489,"language":"C++","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1101,"mirror_url":null,"archived":false,"open_issues_count":653,"license":{"key":"apache-2.0","name":"Apache License 2.0","spdx_id":"Apache-2.0","url":"https://api.github.com/licenses/apache-2.0","node_id":"MDc6TGljZW5zZTI="},"forks":1101,"open_issues":653,"watchers":6489,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/4838"},"html":{"href":"https://github.com/yandex/ClickHouse/pull/4838"},"issue":{"href":"https://api.github.com/repos/yandex/ClickHouse/issues/4838"},"comments":{"href":"https://api.github.com/repos/yandex/ClickHouse/issues/4838/comments"},"review_comments":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/4838/comments"},"review_comment":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/4838/commits"},"statuses":{"href":"https://api.github.com/repos/yandex/ClickHouse/statuses/48a672ddbb136be48884c1aab32b5f0467dc245e"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"blinkov"}}