count distinct values in Oracle

[Anonymous]

Hello,

To count distinct value i used the component tAggregateRow but the volume of my table(11 millions) is huge so it takes a lot of time to finish the job.

So I want to put the query

"select A, count (distinct A) from C

group by A" in talend. 

Any one could help me with this ?

Thanks 

ledoan

[TRF]

select count(*), A from C group by A

[Anonymous]

Sorry, it has the error in my query. 

My query is 

"Select A, count (distinct B) from C

group by A"

which component that i can execute my query in talend

[TRF · Accepted solution]

You can use tOracleInput component with the following query:

select A, count (distinct B) countB from C group by A

You must a Talend schema with 2 fields for the tOracleInput component:

- A, to get the value of A

- countB, to get the count of B for each A group