count distinct values in Oracle

Highlighted
Six Stars

count distinct values in Oracle

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

 


Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: count distinct values in Oracle

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


TRF

All Replies
Forteen Stars TRF
Forteen Stars

Re: count distinct values in Oracle

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

TRF
Six Stars

Re: count distinct values in Oracle

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

 

Forteen Stars TRF
Forteen Stars

Re: count distinct values in Oracle

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


TRF