Apache Pinot Docs
Search…
Histogram
This section contains reference documentation for the HISTOGRAM function.
Returns the count of data points that fall within each bin as a vector. The bins are left-inclusive and right-exclusive, i.e.
[a, b), except for the last one which is inclusive on both sides [a, b].Signatures
- 1.Equal length bins (better performance):
HISTOGRAM(colName, lower, upper, numBins)
- 1.Arbitrary increasing bin edges:
HISTOGRAM(colName, ARRAY[binEdge1, binEdge2, binEdge3, ...])
Usage Examples
- 1.10 equal-length bins
[0, 20), [20, 30) ... [180, 200]
1
SELECT HISTOGRAM(numberOfGames, 0, 200, 10) AS histogram
2
FROM baseballStats
Copied!
histogram
32348,21519,11359,7587,5488,5360,6282,7361,585,0
- 1.6 bins
(- ∞, 1), [1, 10), [10, 50), [50,100), [100,500), [500, 1000]
1
select HISTOGRAM(AtBatting, Array['-Infinity', 1, 10, 50, 100, 500, 1000]) AS histogram
2
from baseballStats
Copied!
histogram
13520,16506,18375,12403,28591,8494
Last modified 1mo ago
Copy link