Cosmos DB Java SDK - CosmosContainer method queryItems() returns an iterable that contains null record(s)

Question

I am currently using the Java SDK to query a container and run a code logic to process the resulting PagedCosmosIterable using JsonNode class. After testing with various types of data that I set up in different containers, I started noticing that queryItems started returning an iterable that contained a null record.

the trimmed logic of the code is basically:

String query = "SELECT c.id, c.partitionKey FROM c";
Stream<JsonNode> responseStream = container.queryItems(query, new CosmosQueryRequestOptions(), JsonNode.class).stream();
responseStream.parallel().foreach(jsonResponse->doSomething(jsonResponse));

The query I am using to fetch the container items is: SELECT c.id, c.partitionKey FROM c
I am also attaching a screenshot showing the data that is present in the container.

Answer 1

Hi @Jae Kim ,

Welcome to Microsoft Q&A platform and thanks for using Azure services.

Regarding your question where CosmosContainer method queryItems() returns null records.

Follow these SDK Performance tips for query.
Sometimes queries may have empty pages even when there are results on a future page. Reasons for this could be:
The SDK could be doing multiple network calls.
The query might be taking a long time to retrieve the documents.
All queries have a continuation token that will allow the query to continue. Be sure to drain the query completely. Learn more about handling multiple pages of results

Also, please check if TTL is enabled on the DB.

Additional helpful links: Query returns empty results set, although the database contains items
why-does-my-azure-cosmos-query-return-empty-results-when-it-should-return-many-r

Hope this helps. Please let us know you inputs.