{"id":"table-decimal-group-extrema","version":"1.0.0","description":"Group table rows by string keys and compute exact decimal extrema results with deterministic ordering.","supported_operations":["group table decimal extrema","exact decimal extrema by category","aggregate decimal extrema by composite key","SQL style grouped decimal extrema","avoid floating point drift in grouped extrema","deterministic table extrema 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.","Equal extrema retain the earliest zero-based input row index; comparison is exact after aligning decimal scales."],"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","minimum","maximum","minimum_row_index","maximum_row_index"],"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},"minimum":{"type":["string","null"]},"maximum":{"type":["string","null"]},"minimum_row_index":{"type":["integer","null"],"minimum":0,"maximum":9999},"maximum_row_index":{"type":["integer","null"],"minimum":0,"maximum":9999}}},"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,"minimum":"1","maximum":"2","minimum_row_index":0,"maximum_row_index":1}],"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,"minimum":"-1","maximum":"-1","minimum_row_index":0,"maximum_row_index":0}],"standard_version":"IBM General Decimal Arithmetic Specification 1.70; SQL:2016"}}],"execute_url":"/v1/tools/table-decimal-group-extrema/versions/1.0.0/execute"}