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?
User contributions licensed under CC BY-SA 3.0