Thursday, August 29, 2013

[Solved] Esper Query Only Generate Insert or ADD event

I have the following Esper query:
SELECT istream column1, column2, column3 
FROM myEventWindow

However, whenever I update any record I always get a ADD event which means in Esper result oldEvent is always null.  What is the problem with my query?

Answer: 

Use irstream instead of istream.  The keyword irstream will include both insert and remove events, that's why it's called irstream.  Change the query to use irstream and my problem is solved. 

SELECT irstream column1, column2, column3 
FROM myEventWindow

8 comments :

  1. Thank you for taking the time to provide us with your valuable information. We
    strive to provide our candidates with excellent care.As always, we appreciate your
    confidence and trust in us.. Peridot Systems Complaints

    ReplyDelete
  2. I’ve been browsing on-line greater than three hours today, but I never discovered any attention-grabbing article like yours. It is beautiful worth sufficient for me. Personally, if all webmasters and bloggers made good content material as you did, the net will be a lot more helpful than ever before.

    J2ee Training in Chennai Adyar

    ReplyDelete
  3. nice blog too informative. looking and reading your points its so impressive. doing more blog like this. i really appreciated doing like this.

    Java Training Institute in Chennai

    ReplyDelete
  4. Provides great information about the concept.It helps an individual to gain knowledge on new techniques.Keep on giving this type of information.
    SEO training in Chennai

    ReplyDelete
  5. nice blog too informative. looking and reading your points its so impressive. doing more blog like this. i really appreciated doing like this.
    Sharepoint Training in Chennai

    ReplyDelete
  6. The blog was very awesome!! Thank you for sharing the article with us. please keep on updating more useful informations...
    Software Testing Training in Chennai

    ReplyDelete
  7. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
    Digital Marketing Company in India

    ReplyDelete
  8. Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..
    GRE Training in Chennai

    ReplyDelete