This discussion is archived
2 Replies Latest reply: Jan 8, 2013 4:06 AM by 900697 RSS

CEP : Filter similar data

900697 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points