payload: {"action":"created","comment":{"url":"https://api.github.com/repos/yandex/ClickHouse/pulls/comments/313866268","pull_request_review_id":274876042,"id":313866268,"node_id":"MDI0OlB1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudDMxMzg2NjI2OA==","diff_hunk":"@@ -65,6 +65,31 @@ You can cancel a long query by pressing Ctrl+C. However, you will still need to\n \n The command-line client allows passing external data (external temporary tables) for querying. For more information, see the section \"External data for query processing\".\n \n+### Formatted Queries {#cli-formatted-queries}","path":"docs/en/interfaces/cli.md","position":4,"original_position":4,"commit_id":"f878ee9decea79291e400742029edc665293155a","original_commit_id":"f878ee9decea79291e400742029edc665293155a","user":{"login":"BayoNet","id":2968367,"node_id":"MDQ6VXNlcjI5NjgzNjc=","avatar_url":"https://avatars3.githubusercontent.com/u/2968367?v=4","gravatar_id":"","url":"https://api.github.com/users/BayoNet","html_url":"https://github.com/BayoNet","followers_url":"https://api.github.com/users/BayoNet/followers","following_url":"https://api.github.com/users/BayoNet/following{/other_user}","gists_url":"https://api.github.com/users/BayoNet/gists{/gist_id}","starred_url":"https://api.github.com/users/BayoNet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BayoNet/subscriptions","organizations_url":"https://api.github.com/users/BayoNet/orgs","repos_url":"https://api.github.com/users/BayoNet/repos","events_url":"https://api.github.com/users/BayoNet/events{/privacy}","received_events_url":"https://api.github.com/users/BayoNet/received_events","type":"User","site_admin":false},"body":"I've called it \"Formatted\" because we have a dial with formatted query string similar to format strings in Python or in C (printf). There is no any other functionality. Queries with parameters sounds strange for me because we don't talk about queries, we talk about interfaces of data I/O.","created_at":"2019-08-14T13:14:16Z","updated_at":"2019-08-14T13:14:17Z","html_url":"https://github.com/yandex/ClickHouse/pull/6490#discussion_r313866268","pull_request_url":"https://api.github.com/repos/yandex/ClickHouse/pulls/6490","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/comments/313866268"},"html":{"href":"https://github.com/yandex/ClickHouse/pull/6490#discussion_r313866268"},"pull_request":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/6490"}},"in_reply_to_id":313826421},"pull_request":{"url":"https://api.github.com/repos/yandex/ClickHouse/pulls/6490","id":307282498,"node_id":"MDExOlB1bGxSZXF1ZXN0MzA3MjgyNDk4","html_url":"https://github.com/yandex/ClickHouse/pull/6490","diff_url":"https://github.com/yandex/ClickHouse/pull/6490.diff","patch_url":"https://github.com/yandex/ClickHouse/pull/6490.patch","issue_url":"https://api.github.com/repos/yandex/ClickHouse/issues/6490","number":6490,"state":"open","locked":false,"title":"DOCAPI-7431: Formatted queries docs","user":{"login":"BayoNet","id":2968367,"node_id":"MDQ6VXNlcjI5NjgzNjc=","avatar_url":"https://avatars3.githubusercontent.com/u/2968367?v=4","gravatar_id":"","url":"https://api.github.com/users/BayoNet","html_url":"https://github.com/BayoNet","followers_url":"https://api.github.com/users/BayoNet/followers","following_url":"https://api.github.com/users/BayoNet/following{/other_user}","gists_url":"https://api.github.com/users/BayoNet/gists{/gist_id}","starred_url":"https://api.github.com/users/BayoNet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BayoNet/subscriptions","organizations_url":"https://api.github.com/users/BayoNet/orgs","repos_url":"https://api.github.com/users/BayoNet/repos","events_url":"https://api.github.com/users/BayoNet/events{/privacy}","received_events_url":"https://api.github.com/users/BayoNet/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- Documentation for #5331 \r\n","created_at":"2019-08-14T11:17:53Z","updated_at":"2019-08-14T13:14:17Z","closed_at":null,"merged_at":null,"merge_commit_sha":"91218231af6ce793fd48bb0843db2dc6bb873bec","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":true},{"id":1310920248,"node_id":"MDU6TGFiZWwxMzEwOTIwMjQ4","url":"https://api.github.com/repos/yandex/ClickHouse/labels/pr-documentation","name":"pr-documentation","color":"007700","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/yandex/ClickHouse/pulls/6490/commits","review_comments_url":"https://api.github.com/repos/yandex/ClickHouse/pulls/6490/comments","review_comment_url":"https://api.github.com/repos/yandex/ClickHouse/pulls/comments{/number}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/issues/6490/comments","statuses_url":"https://api.github.com/repos/yandex/ClickHouse/statuses/f878ee9decea79291e400742029edc665293155a","head":{"label":"BayoNet:en-docs/DOCAPI-7431-substitutions-in-queries","ref":"en-docs/DOCAPI-7431-substitutions-in-queries","sha":"f878ee9decea79291e400742029edc665293155a","user":{"login":"BayoNet","id":2968367,"node_id":"MDQ6VXNlcjI5NjgzNjc=","avatar_url":"https://avatars3.githubusercontent.com/u/2968367?v=4","gravatar_id":"","url":"https://api.github.com/users/BayoNet","html_url":"https://github.com/BayoNet","followers_url":"https://api.github.com/users/BayoNet/followers","following_url":"https://api.github.com/users/BayoNet/following{/other_user}","gists_url":"https://api.github.com/users/BayoNet/gists{/gist_id}","starred_url":"https://api.github.com/users/BayoNet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BayoNet/subscriptions","organizations_url":"https://api.github.com/users/BayoNet/orgs","repos_url":"https://api.github.com/users/BayoNet/repos","events_url":"https://api.github.com/users/BayoNet/events{/privacy}","received_events_url":"https://api.github.com/users/BayoNet/received_events","type":"User","site_admin":false},"repo":{"id":95412423,"node_id":"MDEwOlJlcG9zaXRvcnk5NTQxMjQyMw==","name":"ClickHouse","full_name":"BayoNet/ClickHouse","private":false,"owner":{"login":"BayoNet","id":2968367,"node_id":"MDQ6VXNlcjI5NjgzNjc=","avatar_url":"https://avatars3.githubusercontent.com/u/2968367?v=4","gravatar_id":"","url":"https://api.github.com/users/BayoNet","html_url":"https://github.com/BayoNet","followers_url":"https://api.github.com/users/BayoNet/followers","following_url":"https://api.github.com/users/BayoNet/following{/other_user}","gists_url":"https://api.github.com/users/BayoNet/gists{/gist_id}","starred_url":"https://api.github.com/users/BayoNet/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BayoNet/subscriptions","organizations_url":"https://api.github.com/users/BayoNet/orgs","repos_url":"https://api.github.com/users/BayoNet/repos","events_url":"https://api.github.com/users/BayoNet/events{/privacy}","received_events_url":"https://api.github.com/users/BayoNet/received_events","type":"User","site_admin":false},"html_url":"https://github.com/BayoNet/ClickHouse","description":"ClickHouse is a free analytic DBMS for big data.","fork":true,"url":"https://api.github.com/repos/BayoNet/ClickHouse","forks_url":"https://api.github.com/repos/BayoNet/ClickHouse/forks","keys_url":"https://api.github.com/repos/BayoNet/ClickHouse/keys{/key_id}","collaborators_url":"https://api.github.com/repos/BayoNet/ClickHouse/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/BayoNet/ClickHouse/teams","hooks_url":"https://api.github.com/repos/BayoNet/ClickHouse/hooks","issue_events_url":"https://api.github.com/repos/BayoNet/ClickHouse/issues/events{/number}","events_url":"https://api.github.com/repos/BayoNet/ClickHouse/events","assignees_url":"https://api.github.com/repos/BayoNet/ClickHouse/assignees{/user}","branches_url":"https://api.github.com/repos/BayoNet/ClickHouse/branches{/branch}","tags_url":"https://api.github.com/repos/BayoNet/ClickHouse/tags","blobs_url":"https://api.github.com/repos/BayoNet/ClickHouse/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/BayoNet/ClickHouse/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/BayoNet/ClickHouse/git/refs{/sha}","trees_url":"https://api.github.com/repos/BayoNet/ClickHouse/git/trees{/sha}","statuses_url":"https://api.github.com/repos/BayoNet/ClickHouse/statuses/{sha}","languages_url":"https://api.github.com/repos/BayoNet/ClickHouse/languages","stargazers_url":"https://api.github.com/repos/BayoNet/ClickHouse/stargazers","contributors_url":"https://api.github.com/repos/BayoNet/ClickHouse/contributors","subscribers_url":"https://api.github.com/repos/BayoNet/ClickHouse/subscribers","subscription_url":"https://api.github.com/repos/BayoNet/ClickHouse/subscription","commits_url":"https://api.github.com/repos/BayoNet/ClickHouse/commits{/sha}","git_commits_url":"https://api.github.com/repos/BayoNet/ClickHouse/git/commits{/sha}","comments_url":"https://api.github.com/repos/BayoNet/ClickHouse/comments{/number}","issue_comment_url":"https://api.github.com/repos/BayoNet/ClickHouse/issues/comments{/number}","contents_url":"https://api.github.com/repos/BayoNet/ClickHouse/contents/{+path}","compare_url":"https://api.github.com/repos/BayoNet/ClickHouse/compare/{base}...{head}","merges_url":"https://api.github.com/repos/BayoNet/ClickHouse/merges","archive_url":"https://api.github.com/repos/BayoNet/ClickHouse/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/BayoNet/ClickHouse/downloads","issues_url":"https://api.github.com/repos/BayoNet/ClickHouse/issues{/number}","pulls_url":"https://api.github.com/repos/BayoNet/ClickHouse/pulls{/number}","milestones_url":"https://api.github.com/repos/BayoNet/ClickHouse/milestones{/number}","notifications_url":"https://api.github.com/repos/BayoNet/ClickHouse/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/BayoNet/ClickHouse/labels{/name}","releases_url":"https://api.github.com/repos/BayoNet/ClickHouse/releases{/id}","deployments_url":"https://api.github.com/repos/BayoNet/ClickHouse/deployments","created_at":"2017-06-26T05:44:22Z","updated_at":"2019-08-14T08:27:25Z","pushed_at":"2019-08-14T11:18:14Z","git_url":"git://github.com/BayoNet/ClickHouse.git","ssh_url":"git@github.com:BayoNet/ClickHouse.git","clone_url":"https://github.com/BayoNet/ClickHouse.git","svn_url":"https://github.com/BayoNet/ClickHouse","homepage":"https://clickhouse.yandex","size":125957,"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":2,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":1,"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":2,"open_issues":1,"watchers":0,"default_branch":"master"}},"base":{"label":"yandex:master","ref":"master","sha":"6bcfe51edfd621d4239b2ffea5fba3170c6de1d0","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-08-14T13:10:59Z","pushed_at":"2019-08-14T13:10:37Z","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":133818,"stargazers_count":7886,"watchers_count":7886,"language":"C++","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1342,"mirror_url":null,"archived":false,"disabled":false,"open_issues_count":977,"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":1342,"open_issues":977,"watchers":7886,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/6490"},"html":{"href":"https://github.com/yandex/ClickHouse/pull/6490"},"issue":{"href":"https://api.github.com/repos/yandex/ClickHouse/issues/6490"},"comments":{"href":"https://api.github.com/repos/yandex/ClickHouse/issues/6490/comments"},"review_comments":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/6490/comments"},"review_comment":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/yandex/ClickHouse/pulls/6490/commits"},"statuses":{"href":"https://api.github.com/repos/yandex/ClickHouse/statuses/f878ee9decea79291e400742029edc665293155a"}},"author_association":"CONTRIBUTOR"}}
other: {"actor":{"display_login":"BayoNet"}}