Cosmos DB - Partition key for fixed collections
Can someone advise how to create Fixed collection (throughput - 400 RU) with logical partition keys? Is it possible?
It is necessary for me in order to migrate easily to unlimited collection in the future.
Thanks.
nosql azure-cosmosdb azure-cosmosdb-sqlapi
add a comment |
Can someone advise how to create Fixed collection (throughput - 400 RU) with logical partition keys? Is it possible?
It is necessary for me in order to migrate easily to unlimited collection in the future.
Thanks.
nosql azure-cosmosdb azure-cosmosdb-sqlapi
You cannot migrate from a fixed collection to a partitioned collection without physically copying your data over.
– David Makogon
Nov 25 '18 at 21:14
@DavidMakogon, thanks. What about possibility to create fixed collection with logical partition keys? Since from stackoverflow.com/questions/46017040/… I think so.
– Taras
Nov 25 '18 at 21:20
add a comment |
Can someone advise how to create Fixed collection (throughput - 400 RU) with logical partition keys? Is it possible?
It is necessary for me in order to migrate easily to unlimited collection in the future.
Thanks.
nosql azure-cosmosdb azure-cosmosdb-sqlapi
Can someone advise how to create Fixed collection (throughput - 400 RU) with logical partition keys? Is it possible?
It is necessary for me in order to migrate easily to unlimited collection in the future.
Thanks.
nosql azure-cosmosdb azure-cosmosdb-sqlapi
nosql azure-cosmosdb azure-cosmosdb-sqlapi
edited Nov 25 '18 at 21:14
Taras
asked Nov 25 '18 at 20:35
TarasTaras
11
11
You cannot migrate from a fixed collection to a partitioned collection without physically copying your data over.
– David Makogon
Nov 25 '18 at 21:14
@DavidMakogon, thanks. What about possibility to create fixed collection with logical partition keys? Since from stackoverflow.com/questions/46017040/… I think so.
– Taras
Nov 25 '18 at 21:20
add a comment |
You cannot migrate from a fixed collection to a partitioned collection without physically copying your data over.
– David Makogon
Nov 25 '18 at 21:14
@DavidMakogon, thanks. What about possibility to create fixed collection with logical partition keys? Since from stackoverflow.com/questions/46017040/… I think so.
– Taras
Nov 25 '18 at 21:20
You cannot migrate from a fixed collection to a partitioned collection without physically copying your data over.
– David Makogon
Nov 25 '18 at 21:14
You cannot migrate from a fixed collection to a partitioned collection without physically copying your data over.
– David Makogon
Nov 25 '18 at 21:14
@DavidMakogon, thanks. What about possibility to create fixed collection with logical partition keys? Since from stackoverflow.com/questions/46017040/… I think so.
– Taras
Nov 25 '18 at 21:20
@DavidMakogon, thanks. What about possibility to create fixed collection with logical partition keys? Since from stackoverflow.com/questions/46017040/… I think so.
– Taras
Nov 25 '18 at 21:20
add a comment |
1 Answer
1
active
oldest
votes
You cannot create a fixed collection with a partition key.
Also once a collection is created without a partition key, it cannot be converted to a partitioned one without being migrated form one collection to another.
Thanks, but what about the following sentence: "When you create a "fixed" 10 GB partition, there is only one physical partition allocated, whether you provide a partition key or not. Note that providing a partition key in this case is optional. In summary, you are well off providing a partition key while creating this "fixed" collection, even though all partition key values will be mapped to the single partition." mentioned within stackoverflow.com/questions/46017040/…
– Taras
Nov 25 '18 at 20:50
I now realize (thanks to your link) that your question is essentially a duplicate of the question you linked to.
– David Makogon
Nov 25 '18 at 21:35
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53471683%2fcosmos-db-partition-key-for-fixed-collections%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You cannot create a fixed collection with a partition key.
Also once a collection is created without a partition key, it cannot be converted to a partitioned one without being migrated form one collection to another.
Thanks, but what about the following sentence: "When you create a "fixed" 10 GB partition, there is only one physical partition allocated, whether you provide a partition key or not. Note that providing a partition key in this case is optional. In summary, you are well off providing a partition key while creating this "fixed" collection, even though all partition key values will be mapped to the single partition." mentioned within stackoverflow.com/questions/46017040/…
– Taras
Nov 25 '18 at 20:50
I now realize (thanks to your link) that your question is essentially a duplicate of the question you linked to.
– David Makogon
Nov 25 '18 at 21:35
add a comment |
You cannot create a fixed collection with a partition key.
Also once a collection is created without a partition key, it cannot be converted to a partitioned one without being migrated form one collection to another.
Thanks, but what about the following sentence: "When you create a "fixed" 10 GB partition, there is only one physical partition allocated, whether you provide a partition key or not. Note that providing a partition key in this case is optional. In summary, you are well off providing a partition key while creating this "fixed" collection, even though all partition key values will be mapped to the single partition." mentioned within stackoverflow.com/questions/46017040/…
– Taras
Nov 25 '18 at 20:50
I now realize (thanks to your link) that your question is essentially a duplicate of the question you linked to.
– David Makogon
Nov 25 '18 at 21:35
add a comment |
You cannot create a fixed collection with a partition key.
Also once a collection is created without a partition key, it cannot be converted to a partitioned one without being migrated form one collection to another.
You cannot create a fixed collection with a partition key.
Also once a collection is created without a partition key, it cannot be converted to a partitioned one without being migrated form one collection to another.
answered Nov 25 '18 at 20:39
Nick ChapsasNick Chapsas
3,1511516
3,1511516
Thanks, but what about the following sentence: "When you create a "fixed" 10 GB partition, there is only one physical partition allocated, whether you provide a partition key or not. Note that providing a partition key in this case is optional. In summary, you are well off providing a partition key while creating this "fixed" collection, even though all partition key values will be mapped to the single partition." mentioned within stackoverflow.com/questions/46017040/…
– Taras
Nov 25 '18 at 20:50
I now realize (thanks to your link) that your question is essentially a duplicate of the question you linked to.
– David Makogon
Nov 25 '18 at 21:35
add a comment |
Thanks, but what about the following sentence: "When you create a "fixed" 10 GB partition, there is only one physical partition allocated, whether you provide a partition key or not. Note that providing a partition key in this case is optional. In summary, you are well off providing a partition key while creating this "fixed" collection, even though all partition key values will be mapped to the single partition." mentioned within stackoverflow.com/questions/46017040/…
– Taras
Nov 25 '18 at 20:50
I now realize (thanks to your link) that your question is essentially a duplicate of the question you linked to.
– David Makogon
Nov 25 '18 at 21:35
Thanks, but what about the following sentence: "When you create a "fixed" 10 GB partition, there is only one physical partition allocated, whether you provide a partition key or not. Note that providing a partition key in this case is optional. In summary, you are well off providing a partition key while creating this "fixed" collection, even though all partition key values will be mapped to the single partition." mentioned within stackoverflow.com/questions/46017040/…
– Taras
Nov 25 '18 at 20:50
Thanks, but what about the following sentence: "When you create a "fixed" 10 GB partition, there is only one physical partition allocated, whether you provide a partition key or not. Note that providing a partition key in this case is optional. In summary, you are well off providing a partition key while creating this "fixed" collection, even though all partition key values will be mapped to the single partition." mentioned within stackoverflow.com/questions/46017040/…
– Taras
Nov 25 '18 at 20:50
I now realize (thanks to your link) that your question is essentially a duplicate of the question you linked to.
– David Makogon
Nov 25 '18 at 21:35
I now realize (thanks to your link) that your question is essentially a duplicate of the question you linked to.
– David Makogon
Nov 25 '18 at 21:35
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53471683%2fcosmos-db-partition-key-for-fixed-collections%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You cannot migrate from a fixed collection to a partitioned collection without physically copying your data over.
– David Makogon
Nov 25 '18 at 21:14
@DavidMakogon, thanks. What about possibility to create fixed collection with logical partition keys? Since from stackoverflow.com/questions/46017040/… I think so.
– Taras
Nov 25 '18 at 21:20