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].- 1.Equal length bins (better performance):
HISTOGRAM(colName, lower, upper, numBins)
- 1.Arbitrary increasing bin edges:
HISTOGRAM(colName, ARRAY[binEdge1, binEdge2, binEdge3, ...])
- 1.10 equal-length bins
[0, 20), [20, 30) ... [180, 200]
SELECT HISTOGRAM(numberOfGames, 0, 200, 10) AS histogram
FROM baseballStats
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]
select HISTOGRAM(AtBatting, Array['-Infinity', 1, 10, 50, 100, 500, 1000]) AS histogram
from baseballStats
histogram |
|---|
13520,16506,18375,12403,28591,8494 |
Last modified 1yr ago