Archives of the TeradataForum

Message Posted: Tue, 22 Mar 2005 @ 18:23:38 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Julie

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.

Cheers

Paul

	<Prev	Next>		<<First	<Prev	Next>	Last>>