Group by field jq
Aggregate items by a field value
cat data.json | jq 'group_by(.namespace) | map({ns: .[0].namespace, count: length})'
more jq
all 17 commands →
Delete a field
cat data.json | jq 'del(.metadata.managedFields)'
Convert array to lines
cat data.json | jq -r '.items[].metadata.name'
Merge two JSON objects
jq -s '.[0] * .[1]' base.json override.json
Select non-null fields
jq '[.[] | select(.value != null)]' data.json
Group by field
jq 'group_by(.status) | map({status: .[0].status, count: length})' data.json