Gremlin Query Compilation Error: Column reference R_5[\"FAV\"] cannot be located in the raw records in the current execution pipeline

-1

I am trying to do order by on the results fetched by the following gremlin query in Azure Cosmos DB Gremlin API

g.V().hasLabel('Cons').has('SkId','785159').as('Cons').outE('FAV').as('FAV').inV().hasLabel('RecCat').as('RecCat').select('RecCat','FAV').by('CatName').by('Score')

result of above query:

[
  {
    "RecCat": "Snack",
    "FAV": "0.11"
  },
  {
    "RecCat": "Occasion Recipes",
    "FAV": "0.01"
  },
  {
    "RecCat": "Sides",
    "FAV": "0.05"
  },
  {
    "RecCat": "Lunchs",
    "FAV": "0.01"
  },
  {
    "RecCat": "Mediterran",
    "FAV": "0.01"
  },
  {
    "RecCat": "Dinner",
    "FAV": "0.67"
  }
]

when i try to use the order by on the above query

g.V().hasLabel('Cons').has('SkId','785159').as('Cons').outE('FAV').as('FAV').inV().hasLabel('RecCat').as('RecCat').select('RecCat','FAV').by('CatName').by('FAV').order().by('FAV')

i am getting an exception as follows

Error
Failure in submitting query: g.V().hasLabel('Cons').has('SkId','785159').as('Cons').outE('FAV').as('FAV').inV().hasLabel('RecCat').as('RecCat').select('RecCat','FAV').by('CatName').by('Score').order().by('Score'): "Script eval error: \r\n\nActivityId : ef7b4704-3388-4060-bdb4-65f445a33457\nExceptionType : GraphCompileException\nExceptionMessage :\r\n\tGremlin Query Compilation Error: Column reference R_5[\"FAV\"] cannot be located in the raw records in the current execution pipeline.\nSource : Microsoft.Azure.Cosmos.Gremlin.Core\n\tGremlinRequestId : ef7b4704-3388-4060-bdb4-65f445a33457\n\tContext : graphcompute\n\tScope : graphstg-phyplan\n\tGraphInterOpStatusCode : QuerySyntaxError\n\tHResult : 0x80131500\r\n"

Any help on this?

azure
azure-cosmosdb
gremlin
azure-cosmosdb-gremlinapi
asked on Stack Overflow May 26, 2020 by santhosh kurnapally • edited May 27, 2020 by santhosh kurnapally

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0