This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 48%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Hi
Dose cosmosdb spark 3 support cross partition query. If yes; how can I enable. My below code is not return all data. Can you please help on this.
https://twitter.com/ImAbhishekTomar/status/1531904079085326337
Hi, @Abhishek Tomar Welcome to the Microsoft Q&A forum, and thanks for reaching out.
I think the OLTP spark connector should support it by default, however, I will check with the internal product team and provide you with more details.
You can also check doc here
Regards
Geetha
Hi, @Abhishek Tomar on checking with the internal team, Any read in Spark will be mapped to a query that is executed across all partitions - so cross partition queries are the default. The only thing spezialisiert is that instead of relying on the Aggregate function in queries by pushing them to the Cosmos DB query aggregates will be processed in spark (if desired aggregates can also be pushed to cosmos via custom query, but results of each partition need to be aggregated in spark - so if you push a count into the custom query you would need to sum them in spark to get the total count across all spark partitions.
I hope this information helps.
Please let me know if you need any additional information.
Regards
Geetha
Hi, @Abhishek Tomar I have not heard back from you. Did my answer helpful. if you find the above reply useful. If yes, do click on 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.
Regrads
Geetha