Search code examples
orientdb

Does orient DB support group by operation?

I think the answer is no, but i still want to confirm

My use case is as follows:

1)Get sub graph between source and destination.
2)Then for each node in subgraph obtained in step 1 , do some aggregation Some thing like

select nodeId, sum(mycount) where prop ="value" and prop2 ="value2" and nodeId in [x,y,z ] group by nodeId

Can u do this in orinet DB ?If yes how efficiently?

Solution

  • Group by is supported and it's fast. Have you tried it?