...
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
output = AGGREGATE({ group_by = ['bidder'], aggregations=[ ['MAX', 'price', 'max_price', 'double'] ] }, input) // Parital Aggregate example pa = AGGREGATE({ name='PRE_AGG', aggregations=[ ['count', 'id', 'count', 'PartialAggregate'], ['sum', 'id', 'avgsum', 'PartialAggregate'], ['min', 'id', 'min', 'PartialAggregate'], ['max', 'id', 'max', 'PartialAggregate'] ], outputpa='true' }, nexmark:person ) out = AGGREGATE({ name='AGG', aggregations=[ ['count', 'count', 'count', 'Integer'], ['sum', 'avgsum', 'sum', 'Double'], ['avg', 'avgsum', 'avg', 'Double'], ['min', 'min', 'min', 'Integer'], ['max', 'max', 'max', 'Integer'] ] }, pa ) |
...