Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cosmos DB client cross-partition ORDER BY queries fail #123

Open
ollym opened this issue Apr 23, 2021 · 1 comment
Open

Cosmos DB client cross-partition ORDER BY queries fail #123

ollym opened this issue Apr 23, 2021 · 1 comment
Labels
enhancement New feature or request

Comments

@ollym
Copy link

ollym commented Apr 23, 2021

Full summary of what is wrong is here:
https://stackoverflow.com/questions/50240232/cosmos-db-rest-api-order-by-with-partitioning

Basically CosmosDB has some hacks that allow ORDER BY queries but it requires implementation within the SDK itself, otherwise you get this rather cryptic error message:

The provided cross partition query can not be directly served by the gateway. This is a first chance (internal) exception that all newer clients will know how to handle gracefully. This exception is traced, but unless you see it bubble up as an exception (which only happens on older SDK clients), then you can safely ignore this message.

@jdanyow
Copy link
Member

jdanyow commented Apr 24, 2021

@ollym I didn't try to implement these types of operations in @cfworker/cosmos because they would quickly make apps hit the Worker cpu/memory limits. Now that the workers unbound product exists it might be worth taking a look at what this would entail. I don't have the bandwidth to take something like this on at the moment.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants