Azure Cosmos DB
An Azure NoSQL database service for app development.
1,520 questions
1 answer
Objects and arrays defined in outer scopes are currently not supported inside sortBy predicate
This problem was raised in 2018 and it's still not fixed:…
asked 2020-10-16T19:02:12.467+00:00
Noel Abrahams
1
Reputation point
commented 2020-10-28T19:37:38.397+00:00
![](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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
0 answers
To get all CosmosDB Mongo API collection using foreach and copy Activity
I have 10 collection in CosmosDB with Mongo API and load in BLOB storage , I can able to do for 1 collection using copy activity but cant do for all collection as I have used for each activity but not able to get all collection name in for each…
asked 2020-10-20T06:58:40.28+00:00
![](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(60.8, 97%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Girish13
1
Reputation point
commented 2020-10-28T15:29:17.497+00:00
![](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(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HarithaMaddi-MSFT
10,136
Reputation points
1 answer
One of the answers was accepted by the question author.
Cassandra 3.11.3
I'm currently trying to connect an application (Zipkin) to Cosmos with the Cassandra API however it is complaining because the required minimum supported version is 3.11.3 while its indicating is running 3.11.0. Are there any plans to update Cosmos to…
asked 2020-10-21T20:54:47.443+00:00
![](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(28.799999999999997, 16%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
David Welsh
21
Reputation points
accepted 2020-10-27T22:25:21.203+00:00
David Welsh
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Deleting documents from Mongo API Collection on Azure Cosmos DB
We have a Mongo API Collection implemented on Azure Cosmos DB. I am presently creating a pipeline in Azure Data Factory to implement the following process. Delete all the existing documents in the target Mongo API Collection on Azure Cosmos DB Read…
![](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(272, 40%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGV%3C/text%3E%3C/svg%3E)
0 answers
QnA Maker Bot with CosmosDB for storage
Within the Microsoft Learn, it states I should not create a CosmosDB container, however the next section requires that I populate a container-id. "CosmosDbEndpoint": "<your-cosmosdb-uri>", "CosmosDbAuthKey":…
asked 2020-10-20T20:42:32.89+00:00
![](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(291.2, 61%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
devX
1
Reputation point
commented 2020-10-21T21:42:19.763+00:00
![](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(214.4, 45%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
GiftA-MSFT
11,161
Reputation points
1 answer
Data migration from Oracle to Cosmos-gremlin API
I have one requirement. transfer on-premise data in Oracle to Azure Cosmos -Gremlin API. Data is huge and need to transfer data on daily basis. I read on docs that azure doesn't provides the support for gremlin API. Any idea how I can achieve it. Or if I…
asked 2020-10-19T05:33:55.953+00:00
![](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(70.4, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Bhardwaj, Arunkumar
1
Reputation point
commented 2020-10-21T17:45:50.467+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Unable to call Cosmos db table in the azure function
Below is the code where I am trying to get the Cosmos Db table Api to do some manipulation. code is triggered in an Azure Function . I am not sure what is wrong but it gives the error "Microsoft.Azure.WebJobs.Host: Can't bind CosmosDB to type…
asked 2020-10-19T14:07:48.217+00:00
![](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(240, 24%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Ankit Kumar
91
Reputation points
answered 2020-10-20T15:33:54.68+00:00
![](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(25.6, 10%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure CosmosDB - RU distribution
Hello, Just trying to get my head around Partitioning and RUs. Here is a scenario. We have a container called SalesZones, allocated with say 400 RUs, with a paritionkey on a attribute called ZoneId. There are 10 zones so we have 10 logical…
asked 2020-10-15T04:21:04.467+00:00
![](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(256, 12%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Biju Mathew
481
Reputation points
commented 2020-10-16T11:12:34.977+00:00
![](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(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,586
Reputation points
1 answer
CosmosDb learn sandbox stuck in login page
Hi everyone, Anybody has experiencing stuck on login page when activate sandbox in cosmos db learning below? https://video2.skills-academy.com/en-us/learn/modules/monitor-and-scale-cosmos-db/3-setup
asked 2020-10-16T03:23:53.5+00:00
![](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(281.6, 75%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Muhammad Maliqi Akbar
1
Reputation point Microsoft Employee
answered 2020-10-16T04:57:27.363+00:00
Vaibhav Chaudhari
38,681
Reputation points
4 answers
Unable to read csv file from cosmos gen1 through spark. Pandas read works.
This works, df = pd.read_csv('/dbfs/mnt/ajviswan/forest_efficiency/2020-04-26_2020-05-26.csv') sdf = spark.createDataFrame(df) sdf.head() But spark read does not work. df =…
asked 2020-10-08T15:35:40.867+00:00
![](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(195.2, 91%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ajay Prasadh Viswanathan
1
Reputation point Microsoft Employee
commented 2020-10-14T11:34:54.997+00:00
Ajay Prasadh Viswanathan
1
Reputation point Microsoft Employee
1 answer
Is there anyway to do a free text search or wildcard serach like solr in Azure Cosmos DB Cassandra API?
Hi AzureTeam, We are exploring the Azure Cosmos DB - Cassandra API to migrate from DSE cassandra. Is there anyway to do a free text search or wildcard serach like solr in Azure Cosmos DB Cassandra API? Thanks, Rakesh
asked 2020-09-30T11:21:44.84+00:00
![](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(262.40000000000003, 62%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Gouda, Rakesh - Contractor {PEP}
1
Reputation point
answered 2020-10-12T14:44:44.713+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Unable to add 32-bit Azure DocumentDB ODBC data source
Hello, I am trying to load data from an Azure Cosmos DB into an Excel 2019 spreadsheet. I started by using a data source created with the 64-bit version of the Microsoft Azure Document DB ODBC Driver and was getting errors (architecture mismatch)…
![](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(128, 86%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
How to use Mongoose's sort() function in cosmos DB?
const user = await User.find({ level: 'user' }).sort({ class: 'asc' }).select({ password: 0 }) errmsg:'Error=2, Details=\'Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: f9fb7d60-da8b-4697-b77b-7a83218014e8;…
asked 2020-10-07T08:55:15.423+00:00
![](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(300.8, 35%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
디엔소프트 DNSOFT
196
Reputation points
answered 2020-10-08T08:22:47.783+00:00
디엔소프트 DNSOFT
196
Reputation points
1 answer
One of the answers was accepted by the question author.
Suggest a cloud database solution for downloading large binary file using REST API
There are seem to have many cloud data storage solutions in Azure. Our requirement is to let our 10,000+ smart devices to download firmware that is around 50kB. The device has older Linux distribution in ARM and might not be able to support ready-made…
![](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(275.2, 51%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Azure Function Cosmos DB Output Binding issue
I have a javascript Azure function with an IoTHub trigger and a CosmosDB output. This function decodes the IoTHubMesages and creates multiple JSON objects to be sent to CosmosDB. Shown below is the structure of my function with pieces taken out for…
asked 2020-09-23T15:13:10.407+00:00
![](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(182.40000000000003, 8%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Matt Heagerty
46
Reputation points
accepted 2020-10-01T16:34:14.393+00:00
Matt Heagerty
46
Reputation points
1 answer
Unable to start azure cosmodb emulator in local environment
when i am trying to start azure Cosmo dB emulator I am getting below error: Failed to validating the SSL certificate. Could anyone help me .
asked 2020-09-30T05:56:21.44+00:00
![](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(243.2, 34%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
sadanand mishra
1
Reputation point
commented 2020-09-30T16:27:10.09+00:00
Anurag Sharma
17,586
Reputation points
1 answer
CosmosDb Mongo - index limits
Hi all, I have a collection in cosmosdb, Mongo 3.6. The collection is sharded and has about two million documents. I have three fields indexed, the shard key, and two more "string" fields". I checked my cosmosdb metrics,…
asked 2020-09-21T11:29:32.967+00:00
![](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(192, 45%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
David Ribeiro
82
Reputation points
commented 2020-09-30T14:40:17.823+00:00
Mark Brown - MSFT
2,766
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
how to set ttl on collection of cosmos db while i am creating collection through cosmos db REST API
I am trying to set TTL on collection , I want to set it through code as i am creating collection through making call to cosmos db REST API , I don't have any idea what property name and where to set in In body , in header , as I don't want to set it…
asked 2020-09-28T04:31:07.207+00:00
![](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(28.799999999999997, 95%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Katakia, Akshara
21
Reputation points
commented 2020-09-29T12:14:11.323+00:00
Katakia, Akshara
21
Reputation points
0 answers
Deployed MERN app is not reading data from backend/mongo_db database
I deployed a mern web app https://merncrud.azurewebsites.net/ but its not reading data from database. Also showing Internal Server Error 500 !! (picture attached below). Github repo https://github.com/RiteshK-611/mern_crud.git
asked 2020-09-27T13:10:50.13+00:00
![](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(83.2, 73%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ritesh Kokam
1
Reputation point
commented 2020-09-29T06:21:25.643+00:00
Ryan Hill
26,866
Reputation points Microsoft Employee
1 answer
Can't get Cosmos DB document in DESC order
I have an API query to a Core (SQL) Cosmos DB collection that doesn't work, and I don't know why. I want to get the newest document in the collection by _ts., the JSON body is ... { "query": "SELECT * FROM MyData d ORDER BY d._ts…
asked 2020-09-22T04:31:12.89+00:00
![](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(48, 63%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Phil
96
Reputation points
answered 2020-09-28T08:17:12.017+00:00
Anurag Sharma
17,586
Reputation points