topic Re: count distinct values in Oracle in Talend Studio

count distinct values in Oracle

Anonymous — Fri, 14 Sep 2018 14:10:21 GMT

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

Re: count distinct values in Oracle

TRF — Fri, 14 Sep 2018 14:14:52 GMT

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

Re: count distinct values in Oracle

Anonymous — Fri, 14 Sep 2018 14:34:02 GMT

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

Re: count distinct values in Oracle

TRF — Fri, 14 Sep 2018 14:40:24 GMT

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