2 Replies Latest reply: Jan 8, 2013 6:06 AM by 900697 RSS

    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