Archives of the TeradataForum
Message Posted: Tue, 22 Mar 2005 @ 18:23:38 GMT
I was looking at this myself a few weeks ago.
The manual says
Because QUANTILE uses equal-width histograms to partition the specified data, it does not partition the data equally using equal- height histograms. In other words, do not expect equal row counts per specified quantile. Expect empty quantile histograms when, for example, duplicate values for sort_expression are found in the data.
Hopefully, that answers your question.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|