{"id":"table-decimal-group-sum","version":"1.0.0","description":"Group table rows by string keys and compute exact decimal sum results with deterministic ordering.","supported_operations":["group table decimal sum","exact decimal sum by category","aggregate decimal sum by composite key","SQL style grouped decimal sum","avoid floating point drift in grouped sum","deterministic table sum aggregation"],"unsupported_operations":["ungrouped scalar array statistics","binary floating-point inputs","streaming or window aggregates"],"semantics":["Rows are assigned to composite groups by the exact sequence of group_by string values; groups are emitted in first-seen row order.","Every group key column must exist and contain a well-formed string; value_column must exist and contain a canonical decimal string or null.","null_policy ignore excludes null values and yields null aggregate fields when a group has no non-null values; error rejects the first null value.","Decimal inputs use optional minus, canonical integer syntax, and optional fractional digits; results remove trailing fractional zeros and normalize signed zero to 0.","Sum is exact after aligning decimal scales and may contain at most 105 digits."],"limits":{"max_input_bytes":2097152,"max_rows":10000,"max_columns_per_row":32,"max_group_columns":8,"max_column_name_bytes":64,"max_cell_bytes":256,"max_decimal_digits":100,"max_decimal_scale":50,"max_groups":10000,"max_output_bytes":2097152},"pricing":{"status":"unpriced","charge_usd":null},"input_schema":{"type":"object","additionalProperties":false,"required":["rows","group_by","value_column","null_policy"],"properties":{"rows":{"type":"array","items":{"type":"object","additionalProperties":{"type":["string","null"]},"maxProperties":32},"maxItems":10000},"group_by":{"type":"array","items":{"type":"string","minLength":1,"maxLength":64},"minItems":1,"maxItems":8,"uniqueItems":true},"value_column":{"type":"string","minLength":1,"maxLength":64},"null_policy":{"type":"string","enum":["ignore","error"]}}},"output_schema":{"type":"object","additionalProperties":false,"required":["groups","standard_version"],"properties":{"groups":{"type":"array","items":{"type":"object","additionalProperties":false,"required":["key_values","row_count","value_count","sum"],"properties":{"key_values":{"type":"array","items":{"type":"string"},"minItems":1,"maxItems":8},"row_count":{"type":"integer","minimum":1,"maximum":10000},"value_count":{"type":"integer","minimum":0,"maximum":10000},"sum":{"type":["string","null"]}}},"maxItems":10000},"standard_version":{"type":"string","const":"IBM General Decimal Arithmetic Specification 1.70; SQL:2016"}}},"examples":[{"input":{"rows":[{"g":"A","v":"1"},{"g":"A","v":"2"}],"group_by":["g"],"value_column":"v","null_policy":"ignore"},"output":{"groups":[{"key_values":["A"],"row_count":2,"value_count":2,"sum":"3"}],"standard_version":"IBM General Decimal Arithmetic Specification 1.70; SQL:2016"}},{"input":{"rows":[{"g":"A","v":"-1"},{"g":"A","v":"1.00"}],"group_by":["g"],"value_column":"v","null_policy":"ignore"},"output":{"groups":[{"key_values":["A"],"row_count":2,"value_count":2,"sum":"0"}],"standard_version":"IBM General Decimal Arithmetic Specification 1.70; SQL:2016"}}],"execute_url":"/v1/tools/table-decimal-group-sum/versions/1.0.0/execute"}