Query cosmosdb using partition key

Question

I have an employee dto with department as partitionKey.

How to get number of partition at any given of point of time?
How to query cosmosdb(documentDB) using partitionKey, either query explorer or java api will do?

What I tried:

List<Document> documentList = documentClient.queryDocuments(getCollection().getSelfLink(),"SELECT * FROM root r WHERE r.partitionKey ='" + partitionKey+"'", null).getQueryIterable().toList();

I end up getting IllegalStateException state exception from java api and query exporter also did't give any output. Any help is highly appreciable.

Community · Accepted Answer · 2019-03-22 00:45:07Z

7

Partial answer:

Given the name of Partition Key attribute is department, please change your query to:

List<Document> documentList = 
    documentClient.queryDocuments(
         getCollection().getSelfLink(),
              "SELECT * FROM root r WHERE r.department ='" + 
              partitionKey + "'", null).getQueryIterable().toList();

edited Mar 22, 2019 at 0:45

CommunityBot

11 silver badge

answered May 23, 2017 at 13:53

Gaurav Mantri

137k17 gold badges247 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

lambodar Over a year ago

thanks much @gaurav, is there a way to get number of partition at any given point of time?

Gaurav Mantri Over a year ago

Please see this: stackoverflow.com/questions/43319308/…. Let me know if it helps and I will include it in the answer.

JBirdVegas Over a year ago

I hope partitionKey is not a user controllable input because this is vulnerable to SQLi if it comes from the user

Amit_Hora · Accepted Answer · 2017-05-30 05:05:28Z

1

You can also achieve the same thing by providing the link to collection

List<Document> documentList = documentClient.queryDocuments("/dbs/<yourdbname>/colls/<collectionname>","SELECT * FROM root r WHERE r.department ='" + partitionKey+"'", null).getQueryIterable().toList();

edited May 30, 2017 at 5:05

answered May 30, 2017 at 4:55

Amit_Hora

7081 gold badge9 silver badges28 bronze badges

Collectives™ on Stack Overflow

Query cosmosdb using partition key

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related