Azure Cosmos DB databases can be configured to use a Gremlin API. Via this feature, Cosmos DB aims to provide a compatible server interface for applications using the Tinkerpop Gremlin graph traversal language. Not all Gremlin features are supported by Cosmos DB's implementation.
Questions tagged [azure-cosmosdb-gremlinapi]
283 questions
0
votes
1 answer
Modelling Graph DB for fraud scenario
I'm looking for a way to find links between users to solve a particular fraud scenario.
I've got some high-level linking rules as follows:
Surname + DOB
Mobile + Postcode
Email + Postcode
Mobile + Surname
Mobile + DOB
etc
If we can link a user to…
Ryan.Bartsch
- 3,698
- 1
- 26
- 52
0
votes
1 answer
How to Delete a CosmosDB Vertex using Pyspark
As we can read and write data into cosmosdb using pyspark as follws,
cfg = {
"spark.cosmos.accountEndpoint" : "xx:443/",
"spark.cosmos.accountKey" : "xx==",
"spark.cosmos.database" : "graphdb",
"spark.cosmos.container" : "graph"…
Sneha Nair
- 103
- 9
0
votes
1 answer
Why does looking up a Gremlin vertex after adding one cost so much?
I discovered the following Gremlin query that was charging 60K RUs in Cosmos DB:
g.addV(label, 'plannedmeal')
.property('partitionKey', '84ca17dd-c284-4f47-a839-a75bc27f9097')
.as('meal')
.V('19760224-7ac1-4316-b9a8-1f7a979274b8') <---…
Jonathan Eckman
- 2,071
- 3
- 23
- 49
0
votes
1 answer
Retrieve all vertices from root vertex joined by edges with Gremlin query
How can I retrieve all vertex properties starting from the root vertex in Gremlin query?
We have the following structure:
Root Vertex: Employee
Edges: EdCompany, EdDepartment, EdRole
Vertices: Company, Department, Role
We are trying to receive the…
stfno.me
- 898
- 7
- 24
0
votes
1 answer
CosmosDB Gremlin API - How to insert bulk data through Azure Data Factory (e.g. json to cosmos graph db)
I am using this json for insert vertex...
{
"id": "15",
"label": "organization",
"orgid": [{
"_value": "15",
"id": "5267ec4b-a39e-4d77-8dea-668cb36307bc"
}],
"name": [{
"_value": "org.15",
"id":…
0
votes
0 answers
GraphDB - 1 vertex having multiple properties
Could you please help me understand if we can have multiple array properties in 1 vertex.. For example,
"id": "CU10611973PH",
"label": "Phone-Home",
"type": "vertex",
"properties": {
"PhonePreference": [
{
…
Sneha Nair
- 103
- 9
0
votes
1 answer
Querying details from GraphDB
We are trying to implement Customer oriented details in Graphdb, were with a single query we can fetch the details of a customer such as his address,phone,email etc. We have build it using had address, has email…
Sneha Nair
- 103
- 9
0
votes
1 answer
Gremlin Query Language: how to drop every vertex that is not edged to anything?
As the title suggests. How do I drop every vertex that does not have any edges?
Bendik Skarpnes
- 3
- 1
0
votes
1 answer
CosmosDB gremlin graph: group vertexes and edges by a vertex
Context
I am working with a very complex graph, but for the shake of making it easier to understand and give an answer, I have created the following abstraction/simplification of my graph:
A1 -owns-> B1 -approves-> C1
-approves-> C2
…
Maxinfamily
- 13
- 1
- 4
0
votes
1 answer
StartsWithIgnoreCase - Gremlin Graph DB query
I am trying to get all the data from GraphDB which starts with certain characters along with ignore case. I am able to write a query that will return me the list which starts with some characters but I am not able to perform any ignore-case…
0
votes
0 answers
findByNameContainingIgnoreCase -not working in case of GremlinRepository
I am trying to use findByNameContainingIgnoreCase while working on GremlinRepository... but it is throwing error like - java.lang.UnsupportedOperationException: Unsupported keyword: CONTAINING (1): [IsContaining, Containing, Contains]
Even not…
0
votes
0 answers
cosmos gremlins json data ingest
Azure Cosmos Gremlins API.
Assume Partition key - division
Germline query to add node
g.addV('person').
property('firstName','Thomas').
property('lastName', 'Andersen').
property('age', 44)
How I will insert similar JSON data into cosmos from…
Jack
- 21
- 1
- 5
0
votes
1 answer
cosmos gremline cross container mapping
Cosmos DB Gremlins two graph ( container ) - graph1 & graph 2 .
graph1- - person(node )
graph2- - city(node )
can we make edge between person and city where they are located different container ?
Jack
- 21
- 1
- 5
0
votes
1 answer
Gremlin hasId using property of parent
I would like to filter out by an id. The value of the id is on a property of the parent. Example:
g.V('1234')
.as('parent')
.out()
.has(id, parent.childId). <--- how do I get the parent id?
How would one approach this?
The closest…
Jonathan Eckman
- 2,071
- 3
- 23
- 49
0
votes
1 answer
Querying COSMOS DB graph vertices via REST
Is it possible to use REST services to access vertices in a Cosmos DB graph database? That is, are there REST calls to run Gremlin-like queries?
The "Azure REST API reference", learn.microsoft.com/en-us/rest/api/azure/ has examples such as how to…
