Cosmos DB - Partition key for fixed collections












-1















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.










share|improve this question

























  • 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
















-1















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.










share|improve this question

























  • 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














-1












-1








-1








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.










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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



















  • 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












1 Answer
1






active

oldest

votes


















1














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.






share|improve this answer
























  • 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











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
});


}
});














draft saved

draft discarded


















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









1














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.






share|improve this answer
























  • 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
















1














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.






share|improve this answer
























  • 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














1












1








1







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.






share|improve this answer













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.







share|improve this answer












share|improve this answer



share|improve this answer










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



















  • 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




















draft saved

draft discarded




















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Costa Masnaga

Fotorealismo

Sidney Franklin