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

15 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. 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
  5. 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
  6. Well, this is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a marvelous job! topusgirl

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. Our group of playing specialists have reviewed these casinos, which undergo 카지노 their bonus phrases and circumstances. Check out our greatest online casino in Germany page for more data. The bonuses on offer will change because the event progresses, so positive to|make certain to|remember to} check out at|try} the present World Cup bonuses on offer. For instance, to be able to} unlock the Ignition casino poker sign-up bonus, you should enter the code “IGWPCB100.” Without the code, you can’t seize the bonus. A bonus code is the piece of textual content want to|you should|you have to} enter when prompted to launch a selected bonus. To claim this 24/7 bonus, you should have a Slots Empire account and, as mentioned, you should make both a $30, $75, or a $150 deposit.

    ReplyDelete
  9. Thanks for sharing such informative guide. This post gives me detailed information. I am working as trainer in leading IT training academy offering Linux Training Course in Delhiand i use your guide to educate my students

    ReplyDelete