Questions tagged [azure-cosmosdb-gremlinapi]

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.

283 questions
1
vote
0 answers

What are the usual RUs values you expect when you run simple queries?

I started a short time ago to experiment with gremlin and cosmos DB, with the idea of doing a prototype for a project at work. How do I know if a "Request charge value" is good or bad? For example, I have a query to get a list of flats located in a…
Nils De Winter
  • 1,370
  • 3
  • 11
  • 20
1
vote
1 answer

Azure cosmos db gremline bulk import csv

what will be the best way to load data from csv to Azure cosmos graph ( gremline ) DB? I checked below link for.net https://learn.microsoft.com/en-us/azure/cosmos-db/create-graph-dotnet but not getting full phase for load data from csv . Any…
Jack
  • 21
  • 1
  • 5
1
vote
1 answer

Bitwise operators in Gremlin

Does Gremlin supports bitwise operators in where() (like property & flag > 0)? Maybe something like where(bitIsSet('property', 2)). Could not find anything about that in apache docs but it feels at least strange that this basic operation would not…
1
vote
1 answer

Gremlin: inject() and has() not working together as expected

I need to create vertices without duplication based on a list passed to inject(), the list is very large so I need to use inject(). I tried this but it didn't work: g.inject(["Macka", "Pedro", "Albert"]).unfold().map( coalesce( …
1
vote
0 answers

Cosmos Graph DB: How to resolve ConnectionPoolBusyException

I am using .Net Gremlin SDK(Gremlin.Net 3.4.8) to query Cosmos DB. Very often I am getting error ConnectionPoolBusyException: All 1 connections have reached their MaxInProcessPerConnection limit of 1. Consider increasing either the PoolSize or the…
1
vote
1 answer

Gremlin driver best practices for closing cluster and client objects

I am using gremlin-driver to connect to cosmosDB. I am working with multiple graph instances simultaneously. I am storing the client objects in a cache, and using it to submit gremlin queries. How should I go about closing these on cache evict, when…
Michael Scott
  • 540
  • 2
  • 8
1
vote
0 answers

Limit on the gremlin Query result set size in cosmosDB

in cosmosDB graph i have a vertex named "student" which have the following properties. query: g.V().hasLabel('student').valueMap().limit(1) output: { "StudentID": [ 10000 ], "StudentName": [ "RITM0809903" ], …
1
vote
1 answer

group by not working on the projected values on cosmos DB gremlin API

Hi i am working on the following graph graph model of the current scenario i am traversing from school vertex to subject,games and hobbies vertex so i wrote a below query which is giving me all the student…
1
vote
1 answer

CosmosDB Gremlin: Error: Project By: Next: The provided traverser of key #### maps to nothing

New at Gremlin and CosmosDB I tried to persist two vertices of type "Person". One of them has a phone number the other doesn't. (pk/pk is the PartitionKey) g.addV('Person').property(id,…
1
vote
1 answer

Bulk insertion for gremlin cosmosdb java/scala

I would like to ask if there is anyway to bulk insert data into gremlin cosmos db. I am currently using the gremlin api and it is really slow. I am graph GraphBulkExecutor but unfortunately it only works if you are using C# .Net. Would appreciate if…
1
vote
1 answer

Gremlin query to get affected nodes from the Cosmos graph

We have a Cosmos graph database like below. ie. A,B,C,... are nodes/vertices and edges are as shown by the arrows. Each node/vertex represents a value in SQL table. Process and the requirement are as follows. User modifies node A value in SQL…
Kaf
  • 33,101
  • 7
  • 58
  • 78
1
vote
1 answer

Update a property in all Vertices in Gremlin

I want to update the value of a property in all vertices of one…
1
vote
2 answers

How to move an edge in Gremlin

I am new to Gremlin and working with typescript in the Azure Cosmos DB, which means I am not allowed to use all cool new features like sideEffect ... I have a tree-like scenario, where Vertices are parentOf other Vertices but can only have one own…
Tobi Hin
  • 11
  • 2
1
vote
1 answer

Concatenate of firstName and lastName and perfom searching on this 2 property using Gremlin queries

"label":”employee”, "id": "64c268cc-6a39-4eba-a312-79103a97b837", "entityType":"employee", "organizationId": "d7081ebb-4685-4cb5-ba24-027eeb815a27", "floorId":”36577019-0587-4a15-b784-4b2b0df7a1da”, "officeId":…
1
vote
1 answer

Is it possible to perform case insensitive search in Cosmos DB Gremlin API?

Does Gremlin API support the use of upper, lower, or any other string functions, or any other setting that allows case insensitive search?