Query cosmosdb using partition key

Question

I have an employee dto with department as partitionKey.

1. How to get number of partition at any given of point of time?
2. 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.

Answer 1

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