Message: Cross partition query is required but disabled. Please set x-ms-documentdb-query-enablecrosspartition to true, specify x-ms-documentdb-partitionkey, or revise your query to avoid this exception.

Gerard Church 1

I have a Azure Cosmos DB container in Azure partitioned by 'ticker'. I am using the python SDK to try and make a simply query using the ContainerProxy I receive the following error:

for item in container.query_items('SELECT * FROM scores', enable_cross_partition_query=True):
print(item)

Being a new user to the Cosmos DB, I don't really understand what this means or where to set this parameter and was hoping someone could help me out.

Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-11-05T19:35:13.077+00:00

Hi @Gerard Church ,

Thanks for using Microsoft Q&A !!
Which SDK Version you are using ?

Thanks
Saurabh
Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-11-12T19:19:13.677+00:00

Hi @Gerard Church ,

We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh
Saurabh Sharma 23,816 Reputation points Microsoft Employee

2021-11-16T21:25:06.86+00:00

Hi @Gerard Church ,

Following up to know if you still are having issues and needs any help.

Thanks
Saurabh
Surya Meda 0 Reputation points

2024-10-10T15:35:01.9033333+00:00

we are also facing same issue

Share via

Message: Cross partition query is required but disabled. Please set x-ms-documentdb-query-enablecrosspartition to true, specify x-ms-documentdb-partitionkey, or revise your query to avoid this exception.

Your answer