{"id":"table-decimal-group-rollup","version":"1.0.0","description":"Sum exact decimal strings over deterministic SQL ROLLUP grouping sets with explicit subtotal markers.","supported_operations":["rollup decimal table by dimensions","grouped rollup for json rows","exact decimal rollup table","sql rollup over table","bounded grouped rollup","deterministic rollup groups"],"unsupported_operations":["parse CSV text","floating-point measures","more than six dimensions"],"semantics":["Dimensions are compared as exact well-formed strings; missing and null are the same data-null group.","Generated subtotal cells use subtotal true, while data null cells use subtotal false.","Grouping sets are emitted in structural order; within each set null sorts before strings and strings sort by Unicode code point.","Decimal addition is exact and output is canonical base 10 without exponent or negative zero.","The output is capped at 50000 group rows and 16777216 UTF-8 bytes."],"limits":{"max_input_bytes":16777216,"max_rows":10000,"max_dimensions":6,"max_columns_per_row":16,"max_field_bytes":64,"max_decimal_bytes":256,"max_output_rows":50000,"max_output_bytes":16777216},"pricing":{"status":"unpriced","charge_usd":null},"input_schema":{"type":"object","additionalProperties":false,"required":["rows","dimensions","measure"],"properties":{"rows":{"type":"array","maxItems":10000,"items":{"type":"object","additionalProperties":{"type":["string","null"]},"maxProperties":16}},"dimensions":{"type":"array","minItems":1,"maxItems":6,"uniqueItems":true,"items":{"type":"string","minLength":1,"maxLength":64}},"measure":{"type":"string","minLength":1,"maxLength":64}}},"output_schema":{"type":"object","additionalProperties":false,"required":["standard_version","groups"],"properties":{"standard_version":{"type":"string","const":"ISO/IEC 9075-2:2016"},"groups":{"type":"array","maxItems":50000,"items":{"type":"object","additionalProperties":false,"required":["dimensions","count","sum"],"properties":{"dimensions":{"type":"array","maxItems":6,"items":{"type":"object","additionalProperties":false,"required":["value","subtotal"],"properties":{"value":{"type":["string","null"]},"subtotal":{"type":"boolean"}}}},"count":{"type":"integer","minimum":0,"maximum":10000},"sum":{"type":"string","pattern":"^-?(0|[1-9][0-9]*)(\\.[0-9]+)?$"}}}}}},"examples":[{"input":{"rows":[{"region":"east","amount":"1.1"},{"region":"east","amount":"2.2"}],"dimensions":["region"],"measure":"amount"},"output":{"standard_version":"ISO/IEC 9075-2:2016","groups":[{"dimensions":[{"value":"east","subtotal":false}],"count":2,"sum":"3.3"},{"dimensions":[{"value":null,"subtotal":true}],"count":2,"sum":"3.3"}]}},{"input":{"rows":[{"region":null,"amount":"2.0"}],"dimensions":["region"],"measure":"amount"},"output":{"standard_version":"ISO/IEC 9075-2:2016","groups":[{"dimensions":[{"value":null,"subtotal":false}],"count":1,"sum":"2"},{"dimensions":[{"value":null,"subtotal":true}],"count":1,"sum":"2"}]}}],"execute_url":"/v1/tools/table-decimal-group-rollup/versions/1.0.0/execute"}