How can we improve Azure Cosmos DB?

CosmosDB Graph API should support array types inside Gremlin properties

Currently, the CosmosDB Graph API does not support array types inside of Gremlin properties. This forces users to rebuild their graph models to match what the Graph API requires. The CosmosDB Graph API should support array types inside of Gremlin properties.

28 votes
Vote
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
You have left! (?) (thinking…)
AdminCSE Feedback (Business Analyst, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    In the current stage:
    http://tinkerpop.apache.org/docs/current/reference/#vertex-properties
    .property(list, 'name', 'm. a. rodriguez')
    is working for vertices. Arrays in Edges are not working.

    Cosmos DB tries to focus everything on SQL Query Language. If you have Arrays in properties, you might come into trouble. In future Cosmos Db Versions (so if you create a new one in Azure) , arrays wont be supported. Therefore, the opportunity to connect the DB with Elasticsearch or Azure Search will become possible. This can only happen if you can write plain SQL.

    If you need an array for now, you have to build Edges with those values. Sure this might be a big overhead for you.

    If you need it so badly, you might go to Janusgraph, neo4j or Titan with native support for that. Janusgraph also has Arrays in Edges (properties). Good Luck ;)

  • Seb commented  ·   ·  Flag as inappropriate

    Not supporting arrays is a silly mistake. It'd be like having JavaScript in Edge without array support.

  • Alex Anikiiev commented  ·   ·  Flag as inappropriate

    Sample data structure

    label: 'book1',
    name: 'book1,
    tags: ['science', 'fiction']

    The query would be "books belonging to fiction'
    So at least one tag is required to qualify a book

Feedback and Knowledge Base