Forum Stats

  • 3,853,758 Users
  • 2,264,266 Discussions
  • 7,905,443 Comments

Discussions

CEP : Filter similar data

900697
900697 Member Posts: 50
edited Jan 8, 2013 7:06AM in Complex Event Processing
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

Answers

This discussion has been closed.