I have a json data similar to the example given below { "name":"srini", "date":"20160801", "distribution": { "20":1, "10":2, "10":1, "15":2, "10":3, "15":4, "20":3, "30":4 } } { "name":"srini2", "date":"20160802", "distribution": { "3":1, "1":2, "4":1, "1":2, "1":1 "3":3, "1":4, "4":3, "1":4 } } I want to do bucketing based on the keys in the distribution field. Buckets should be like (1,2) and (3,4) and sum up all the values in each bucket. Expected result is like following: date bucket1 bucket2 20160801 55 75 20160802 10 10 ... View more