T2 Queries & Group-By (2)

CREATE Accumulator

USING query-region, resolution, initial-val, ...

SELECT acc, aggregate(transform(input))

FROM Accumulator as acc LEFT OUTER JOINS

Dataset as input

WHERE query-region ^ input

AND acc IN

Accumulator.navigate(mapping(input.access()))

GROUP BY acc

Multi-step queries corresponds to a chain of GROUP-BY queries

Previous slide

Next slide

Back to first slide

View graphic version