Using 1.7.6 version and document api.
Had a "TEST" class with the following properties.
operationName - STRING
reqMsgSize- INTEGER
createdDate - DATETIME
Trying to do group by on the combination of "operationName", minutes of
"createdDate" and aggregate on the "reqMsgSize" with the following query.
SELECT operationName, createdDate.format('m') AS minuteAlias,
sum(reqMsgSize) as totSize FROM TEST GROUP BY operationName, minuteAlias
Expected to return multiple records on the unique combination of
operationName, minuteAlias, instead it returns the 1 record which is last.
Ignores the minuteAlias part while aggregation.
Expected Result:
OperationName minuteAlias totSize
x 1 1000
x 2 2000
x 3 1000
Actual Result(Error)
OperationName minuteAlias totSize
x 3 6000
Thanks
Moksh
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
