{"action":"created","comment":{"url":"https://api.github.com/repos/basho/basho_docs/pulls/comments/71795997","id":71795997,"diff_hunk":"@@ -23,20 +23,20 @@ canonical_link: \"https://docs.basho.com/riak/ts/latest/learn-about/bestpractices\n There are many ways to interact with and use Riak TS. This page will give recommendations for structuring your storage region (DDL) and choosing your quanta.\n \n \n-## DDL Definition\n+## TS Table Schema\n \n-One of the first things you will encounter setting up Riak TS is defining storage regions, also known as Data Definition Language (DDL). Creating a table will specify the DDL and compile it, which will create a Riak [bucket][glossary bucket]. The bucket information is passed around the ring.\n+One of the first things you will encounter in setting up Riak TS is defining a TS table's schema.  You use Data Definition Language (DDL), specifically the `CREATE TABLE` statement, to create a new table. When you create a TS Table, the data structure provided in the `CREATE TABLE` statement is compiled and passed around the Riak TS cluster.\n \n-There are two reasons that how you set up your DDL is really important:\n+The design of your TS table schema is really important because:\n \n-1. The values you choose for the [partition key][table arch] will impact the speed of your query returns. \n-2. Once activated, the bucket definition cannot be changed, so the DDL cannot be changed either.\n+1. The values you choose for the [partition key][table arch] will impact the speed of your query returns.\n+2. Once activated, the TS table schema cannot be changed.\n \n-To help speed the performance of Riak TS and avoid recreating DDL definitions, think about the most common queries you will be executing and what tools you will be using to process the data. The answers to those will determine what values you use in the primary key.\n+To help speed the performance of Riak TS and avoid destroying and recreating tables to change their definitions, think about the most common queries you will be executing and what tools you will be using to process the data. The answers to those will determine what values you use in the [primary key][table arch].","path":"content/riak/ts/1.3.0/learn-about/bestpractices.md","position":19,"original_position":19,"commit_id":"1bfbaacff92b48b3a382fb940da1ae7ade62cc89","original_commit_id":"1bfbaacff92b48b3a382fb940da1ae7ade62cc89","user":{"login":"TheOnlyRew","id":361216,"avatar_url":"https://avatars.githubusercontent.com/u/361216?v=3","gravatar_id":"","url":"https://api.github.com/users/TheOnlyRew","html_url":"https://github.com/TheOnlyRew","followers_url":"https://api.github.com/users/TheOnlyRew/followers","following_url":"https://api.github.com/users/TheOnlyRew/following{/other_user}","gists_url":"https://api.github.com/users/TheOnlyRew/gists{/gist_id}","starred_url":"https://api.github.com/users/TheOnlyRew/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TheOnlyRew/subscriptions","organizations_url":"https://api.github.com/users/TheOnlyRew/orgs","repos_url":"https://api.github.com/users/TheOnlyRew/repos","events_url":"https://api.github.com/users/TheOnlyRew/events{/privacy}","received_events_url":"https://api.github.com/users/TheOnlyRew/received_events","type":"User","site_admin":false},"body":"\"The answers to those will determine\" -> \"The answers to those questions will determine\"","created_at":"2016-07-21T22:03:24Z","updated_at":"2016-07-21T22:03:24Z","html_url":"https://github.com/basho/basho_docs/pull/2173#discussion_r71795997","pull_request_url":"https://api.github.com/repos/basho/basho_docs/pulls/2173","_links":{"self":{"href":"https://api.github.com/repos/basho/basho_docs/pulls/comments/71795997"},"html":{"href":"https://github.com/basho/basho_docs/pull/2173#discussion_r71795997"},"pull_request":{"href":"https://api.github.com/repos/basho/basho_docs/pulls/2173"}}},"pull_request":{"url":"https://api.github.com/repos/basho/basho_docs/pulls/2173","id":78244271,"html_url":"https://github.com/basho/basho_docs/pull/2173","diff_url":"https://github.com/basho/basho_docs/pull/2173.diff","patch_url":"https://github.com/basho/basho_docs/pull/2173.patch","issue_url":"https://api.github.com/repos/basho/basho_docs/issues/2173","number":2173,"state":"open","locked":false,"title":"Fix a series of small issues with TS docs","user":{"login":"laurenrother","id":2624486,"avatar_url":"https://avatars.githubusercontent.com/u/2624486?v=3","gravatar_id":"","url":"https://api.github.com/users/laurenrother","html_url":"https://github.com/laurenrother","followers_url":"https://api.github.com/users/laurenrother/followers","following_url":"https://api.github.com/users/laurenrother/following{/other_user}","gists_url":"https://api.github.com/users/laurenrother/gists{/gist_id}","starred_url":"https://api.github.com/users/laurenrother/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laurenrother/subscriptions","organizations_url":"https://api.github.com/users/laurenrother/orgs","repos_url":"https://api.github.com/users/laurenrother/repos","events_url":"https://api.github.com/users/laurenrother/events{/privacy}","received_events_url":"https://api.github.com/users/laurenrother/received_events","type":"User","site_admin":false},"body":"* Fix issue #1966 (DOC-268)\r\n* Fix issue #1968 (DOC-270) \r\n* Fix issue DOC-382\r\n* Fix issue DOC-402\r\n* Fix issue DOC-398\r\n* Fix issue DOC-416\r\n* Fix issue #2103 (DOC-405)\r\n* Fix issue DOC-396\r\n* Fix issue DOC-456","created_at":"2016-07-21T01:12:56Z","updated_at":"2016-07-21T22:03:24Z","closed_at":null,"merged_at":null,"merge_commit_sha":"79a0ea6b09dcefad496458598f40bdb3c80bcf54","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/basho/basho_docs/pulls/2173/commits","review_comments_url":"https://api.github.com/repos/basho/basho_docs/pulls/2173/comments","review_comment_url":"https://api.github.com/repos/basho/basho_docs/pulls/comments{/number}","comments_url":"https://api.github.com/repos/basho/basho_docs/issues/2173/comments","statuses_url":"https://api.github.com/repos/basho/basho_docs/statuses/1bfbaacff92b48b3a382fb940da1ae7ade62cc89","head":{"label":"basho:lr/tsissues","ref":"lr/tsissues","sha":"1bfbaacff92b48b3a382fb940da1ae7ade62cc89","user":{"login":"basho","id":176293,"avatar_url":"https://avatars.githubusercontent.com/u/176293?v=3","gravatar_id":"","url":"https://api.github.com/users/basho","html_url":"https://github.com/basho","followers_url":"https://api.github.com/users/basho/followers","following_url":"https://api.github.com/users/basho/following{/other_user}","gists_url":"https://api.github.com/users/basho/gists{/gist_id}","starred_url":"https://api.github.com/users/basho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/basho/subscriptions","organizations_url":"https://api.github.com/users/basho/orgs","repos_url":"https://api.github.com/users/basho/repos","events_url":"https://api.github.com/users/basho/events{/privacy}","received_events_url":"https://api.github.com/users/basho/received_events","type":"Organization","site_admin":false},"repo":{"id":2401217,"name":"basho_docs","full_name":"basho/basho_docs","owner":{"login":"basho","id":176293,"avatar_url":"https://avatars.githubusercontent.com/u/176293?v=3","gravatar_id":"","url":"https://api.github.com/users/basho","html_url":"https://github.com/basho","followers_url":"https://api.github.com/users/basho/followers","following_url":"https://api.github.com/users/basho/following{/other_user}","gists_url":"https://api.github.com/users/basho/gists{/gist_id}","starred_url":"https://api.github.com/users/basho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/basho/subscriptions","organizations_url":"https://api.github.com/users/basho/orgs","repos_url":"https://api.github.com/users/basho/repos","events_url":"https://api.github.com/users/basho/events{/privacy}","received_events_url":"https://api.github.com/users/basho/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/basho/basho_docs","description":"Basho Products Documentation","fork":false,"url":"https://api.github.com/repos/basho/basho_docs","forks_url":"https://api.github.com/repos/basho/basho_docs/forks","keys_url":"https://api.github.com/repos/basho/basho_docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/basho/basho_docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/basho/basho_docs/teams","hooks_url":"https://api.github.com/repos/basho/basho_docs/hooks","issue_events_url":"https://api.github.com/repos/basho/basho_docs/issues/events{/number}","events_url":"https://api.github.com/repos/basho/basho_docs/events","assignees_url":"https://api.github.com/repos/basho/basho_docs/assignees{/user}","branches_url":"https://api.github.com/repos/basho/basho_docs/branches{/branch}","tags_url":"https://api.github.com/repos/basho/basho_docs/tags","blobs_url":"https://api.github.com/repos/basho/basho_docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/basho/basho_docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/basho/basho_docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/basho/basho_docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/basho/basho_docs/statuses/{sha}","languages_url":"https://api.github.com/repos/basho/basho_docs/languages","stargazers_url":"https://api.github.com/repos/basho/basho_docs/stargazers","contributors_url":"https://api.github.com/repos/basho/basho_docs/contributors","subscribers_url":"https://api.github.com/repos/basho/basho_docs/subscribers","subscription_url":"https://api.github.com/repos/basho/basho_docs/subscription","commits_url":"https://api.github.com/repos/basho/basho_docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/basho/basho_docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/basho/basho_docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/basho/basho_docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/basho/basho_docs/contents/{+path}","compare_url":"https://api.github.com/repos/basho/basho_docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/basho/basho_docs/merges","archive_url":"https://api.github.com/repos/basho/basho_docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/basho/basho_docs/downloads","issues_url":"https://api.github.com/repos/basho/basho_docs/issues{/number}","pulls_url":"https://api.github.com/repos/basho/basho_docs/pulls{/number}","milestones_url":"https://api.github.com/repos/basho/basho_docs/milestones{/number}","notifications_url":"https://api.github.com/repos/basho/basho_docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/basho/basho_docs/labels{/name}","releases_url":"https://api.github.com/repos/basho/basho_docs/releases{/id}","deployments_url":"https://api.github.com/repos/basho/basho_docs/deployments","created_at":"2011-09-16T18:47:02Z","updated_at":"2016-07-07T17:35:13Z","pushed_at":"2016-07-21T20:24:53Z","git_url":"git://github.com/basho/basho_docs.git","ssh_url":"git@github.com:basho/basho_docs.git","clone_url":"https://github.com/basho/basho_docs.git","svn_url":"https://github.com/basho/basho_docs","homepage":"http://docs.basho.com","size":44918,"stargazers_count":124,"watchers_count":124,"language":"CSS","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":133,"mirror_url":null,"open_issues_count":148,"forks":133,"open_issues":148,"watchers":124,"default_branch":"master"}},"base":{"label":"basho:master","ref":"master","sha":"bdc6502601ce4801cc71d6dbb5079eaab115e0af","user":{"login":"basho","id":176293,"avatar_url":"https://avatars.githubusercontent.com/u/176293?v=3","gravatar_id":"","url":"https://api.github.com/users/basho","html_url":"https://github.com/basho","followers_url":"https://api.github.com/users/basho/followers","following_url":"https://api.github.com/users/basho/following{/other_user}","gists_url":"https://api.github.com/users/basho/gists{/gist_id}","starred_url":"https://api.github.com/users/basho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/basho/subscriptions","organizations_url":"https://api.github.com/users/basho/orgs","repos_url":"https://api.github.com/users/basho/repos","events_url":"https://api.github.com/users/basho/events{/privacy}","received_events_url":"https://api.github.com/users/basho/received_events","type":"Organization","site_admin":false},"repo":{"id":2401217,"name":"basho_docs","full_name":"basho/basho_docs","owner":{"login":"basho","id":176293,"avatar_url":"https://avatars.githubusercontent.com/u/176293?v=3","gravatar_id":"","url":"https://api.github.com/users/basho","html_url":"https://github.com/basho","followers_url":"https://api.github.com/users/basho/followers","following_url":"https://api.github.com/users/basho/following{/other_user}","gists_url":"https://api.github.com/users/basho/gists{/gist_id}","starred_url":"https://api.github.com/users/basho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/basho/subscriptions","organizations_url":"https://api.github.com/users/basho/orgs","repos_url":"https://api.github.com/users/basho/repos","events_url":"https://api.github.com/users/basho/events{/privacy}","received_events_url":"https://api.github.com/users/basho/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/basho/basho_docs","description":"Basho Products Documentation","fork":false,"url":"https://api.github.com/repos/basho/basho_docs","forks_url":"https://api.github.com/repos/basho/basho_docs/forks","keys_url":"https://api.github.com/repos/basho/basho_docs/keys{/key_id}","collaborators_url":"https://api.github.com/repos/basho/basho_docs/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/basho/basho_docs/teams","hooks_url":"https://api.github.com/repos/basho/basho_docs/hooks","issue_events_url":"https://api.github.com/repos/basho/basho_docs/issues/events{/number}","events_url":"https://api.github.com/repos/basho/basho_docs/events","assignees_url":"https://api.github.com/repos/basho/basho_docs/assignees{/user}","branches_url":"https://api.github.com/repos/basho/basho_docs/branches{/branch}","tags_url":"https://api.github.com/repos/basho/basho_docs/tags","blobs_url":"https://api.github.com/repos/basho/basho_docs/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/basho/basho_docs/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/basho/basho_docs/git/refs{/sha}","trees_url":"https://api.github.com/repos/basho/basho_docs/git/trees{/sha}","statuses_url":"https://api.github.com/repos/basho/basho_docs/statuses/{sha}","languages_url":"https://api.github.com/repos/basho/basho_docs/languages","stargazers_url":"https://api.github.com/repos/basho/basho_docs/stargazers","contributors_url":"https://api.github.com/repos/basho/basho_docs/contributors","subscribers_url":"https://api.github.com/repos/basho/basho_docs/subscribers","subscription_url":"https://api.github.com/repos/basho/basho_docs/subscription","commits_url":"https://api.github.com/repos/basho/basho_docs/commits{/sha}","git_commits_url":"https://api.github.com/repos/basho/basho_docs/git/commits{/sha}","comments_url":"https://api.github.com/repos/basho/basho_docs/comments{/number}","issue_comment_url":"https://api.github.com/repos/basho/basho_docs/issues/comments{/number}","contents_url":"https://api.github.com/repos/basho/basho_docs/contents/{+path}","compare_url":"https://api.github.com/repos/basho/basho_docs/compare/{base}...{head}","merges_url":"https://api.github.com/repos/basho/basho_docs/merges","archive_url":"https://api.github.com/repos/basho/basho_docs/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/basho/basho_docs/downloads","issues_url":"https://api.github.com/repos/basho/basho_docs/issues{/number}","pulls_url":"https://api.github.com/repos/basho/basho_docs/pulls{/number}","milestones_url":"https://api.github.com/repos/basho/basho_docs/milestones{/number}","notifications_url":"https://api.github.com/repos/basho/basho_docs/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/basho/basho_docs/labels{/name}","releases_url":"https://api.github.com/repos/basho/basho_docs/releases{/id}","deployments_url":"https://api.github.com/repos/basho/basho_docs/deployments","created_at":"2011-09-16T18:47:02Z","updated_at":"2016-07-07T17:35:13Z","pushed_at":"2016-07-21T20:24:53Z","git_url":"git://github.com/basho/basho_docs.git","ssh_url":"git@github.com:basho/basho_docs.git","clone_url":"https://github.com/basho/basho_docs.git","svn_url":"https://github.com/basho/basho_docs","homepage":"http://docs.basho.com","size":44918,"stargazers_count":124,"watchers_count":124,"language":"CSS","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":133,"mirror_url":null,"open_issues_count":148,"forks":133,"open_issues":148,"watchers":124,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/basho/basho_docs/pulls/2173"},"html":{"href":"https://github.com/basho/basho_docs/pull/2173"},"issue":{"href":"https://api.github.com/repos/basho/basho_docs/issues/2173"},"comments":{"href":"https://api.github.com/repos/basho/basho_docs/issues/2173/comments"},"review_comments":{"href":"https://api.github.com/repos/basho/basho_docs/pulls/2173/comments"},"review_comment":{"href":"https://api.github.com/repos/basho/basho_docs/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/basho/basho_docs/pulls/2173/commits"},"statuses":{"href":"https://api.github.com/repos/basho/basho_docs/statuses/1bfbaacff92b48b3a382fb940da1ae7ade62cc89"}}}}
{"actor":{"display_login":"TheOnlyRew"}}