CEP : Filter similar data

900697

Hi,

I don't want to report duplicate records as putput of CEP even though CEP source output duplicate records.

How to filter duplicate records along with WHERE conditions in CQL.

The Query:

Select id,time,location from channel
where id = "1786-568"

If inputs are:

1786-568,1:20,USA
1786-568,1:20,USA
1786-568,1:30,USA
1786-524,1:30,USA

Output should be like:
1786-568,1:20,USA
1786-568,1:30,USA
1786-524,1:30,USA

Please help.

Thanks,
Sri

Unmesh

You can use 'distinct' keyword in SELECT list of your CQL query.
http://docs.oracle.com/cd/E23943_01/apirefs.1111/e12048/cqlstatements.htm#CQLLR1399

900697

Thanks.

I used the group by class in CQL Query. Its also working fine.

Regards,
Sri