Unable to query Cosmos DB using numeric partition key

Question

I am trying to use a numeric field as a partition key but I am unable to run stored procedures on them. I am not sure if I am doing something wrong or if it is not possible.

I have two collections with two different partition keys.

A sample document from collection 1

{
 "id":"1",
 "group": "a"
}

A sample document from collection 2

{
 "id":"1",
 "group": 1
}

The difference is that the group field in second collection does not have double quotes around it.

Both the collections have group as the partition key and I am trying to execute the sample stored procedure provided in the Azure Portal for Cosmos DB.

While i am able to run the first collection successfully, the second collection produces an error of "no docs found".

I am importing the data from sql server database and the int fields are imported without double quotes. I searched quite a lot but could not find documentation relating to numeric partition key without double quotes.

Is it possible to do partition keys from numeric fields?? Any help appreciated as this field is the best fit for my collection for partitioning and would be really useful.

score 2 · Accepted Answer · answered Apr 26 '19 at 01:16

Please don't worry about the numeric partition key which is supported in the cosmos db stored procedure definitely. You did everything rightly.You met the unexpected results because azure portal identify the partition key input as String type even though you filled Number type.

You could test it with cosmos db sdk or rest api. For example, java sdk sample as below:

import com.microsoft.azure.documentdb.*;

public class ExecuteSPTest {

    static private String YOUR_COSMOS_DB_ENDPOINT = "https://***.documents.azure.com:443/";
    static private String YOUR_COSMOS_DB_MASTER_KEY = "***";

    public static void main(String[] args) throws DocumentClientException {

        DocumentClient client = new DocumentClient(
                YOUR_COSMOS_DB_ENDPOINT,
                YOUR_COSMOS_DB_MASTER_KEY,
                new ConnectionPolicy(),
                ConsistencyLevel.Session);

        RequestOptions options = new RequestOptions();
        PartitionKey partitionKey = new PartitionKey(1);
        options.setPartitionKey(partitionKey);

        StoredProcedureResponse queryResults = client.executeStoredProcedure(
                "/dbs/db/colls/group/sprocs/sample",
                options,
                null);

        String document = queryResults.getResponseAsString();

        System.out.println(document);

    }
}

Output:

Thanks for the response! Is it possible to query in the portal or is the only option through the SDK? — Interested_Programmer, Apr 26 '19 at 14:41
@Interested_Programmer So far,based on my observation,it is only supported by sdk.But you could create a feedback to cosmos db team then follow the process of that. Thank you. — Jay Gong, Apr 28 '19 at 13:52

Unable to query Cosmos DB using numeric partition key

1 Answers1