You are not logged in.

Unanswered posts

Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at We look forward to hearing from you there!

#1 2008-08-03 23:57:12

4 posts

BenBor said:

[resolved] Difference between "unique" and "Distinct"

When I run the profiler, the 'simple' stats include two different counts: one for "unique" values and the other for "Distinct" values.
I don't understand the difference between them.

Can someone please explain how I should interpret the case when:
Row Count = 658,645 (OK, I think I understand this one smile )
Null Count = 0 (I understand this one too smile )
Distinct Count = 5,097
Unique Count = 541
Duplicate Count = 4,556


#2 2008-08-04 08:51:35

Talend Team

scorreia said:

Re: [resolved] Difference between "unique" and "Distinct"

"Distinct count" counts the number of distinct values of your column (SELECT DISTINCT ...)
"Unique count" counts the number of distinct values with only one instance. It is necessarily less or equal to "distinct counts"
"Duplicate count" count the number of values appearing more than once.

You have the relation:
"Duplicate count" + "Unique count" = "Distinct count"

For example,
a,a,a,a,b,b,c,d,e => 9 values, 5 distinct values, 3 unique values, 2 duplicate values.

Thank you for your support,
Sebastiao Correia.


Board footer

Talend Contributor Agreement - Talend Website Privacy Policy