Hi Saneth, Thanks, it seems better I create db and tables and check the validity.
Appreciate your help. On Mon, Oct 27, 2014 at 11:18 AM, Saneth Dharmakeerthi <[email protected]> wrote: > HI Chamin, > > Try this and see.. [assuming that rejectedCount is a table] > > from inputStream [(pan == rejectedCount.pan and rejectedCount. > rejected_count>=3) in rejectedCount)] > select inputStream.pan > insert into rejectedThreeTimesStream; > > Thanks and Best Regards, > > Saneth Dharmakeerthi > Senior Software Engineer > WSO2, Inc. > Mobile: +94772325511 > > On Mon, Oct 27, 2014 at 11:09 AM, Chamin Nalinda <[email protected]> wrote: > >> follow the following query >> >> >> // check pan count>=3 if yes rejectedThreeTimesStream >> >> from inputStream join rejectedCount[rejected_count>=3] >> >> on inputStream.pan = rejectedCount.pan >> >> select inputStream.pan >> >> insert into rejectedThreeTimesStream >> >> //else >> >> from inputStream join rejectedCount[rejectedCount <3] >> >> on inputStream.pan = rejectedCount.pan >> >> select * >> >> insert into OutStream >> >> >> On Mon, Oct 27, 2014 at 11:04 AM, Chamin Nalinda <[email protected]> wrote: >> >>> Hi All, >>> >>> What I need from the below query to check, >>> >>> if the rejected_count >= 3, >>> forward stream to rejectedThreeTimesStream >>> else >>> forward to outStream >>> >>> Here, rejectedCount table is a mysql table. >>> >>> Is this valid (below query) ? >>> >>> >>> from inputStream join rejectedCount[rejected_count>=3] >>> >>> on inputStream.pan = countTable.pan >>> >>> select inputStream.pan >>> insert into rejectedThreeTimesStream >>> >>> >>> What is the recommended way of checking a mysql db table condition with >>> incoming stream ? >>> >>> Regards >>> >>> >>> -- >>> *Chamin Nalinda* >>> >>> Intern - Engineering >>> WSO2 Inc. http://www.wso2.com >>> lean.enterprise.middleware >>> >>> Mobile: (+94) 77 241 66 04 >>> Linkedin: https://www.linkedin.com/in/chaminnalinda >>> Web: http://www.ckreativity.com >>> Blog: http://techspiro.blogspot.com/ >>> >>> >> >> >> -- >> *Chamin Nalinda* >> >> Intern - Engineering >> WSO2 Inc. http://www.wso2.com >> lean.enterprise.middleware >> >> Mobile: (+94) 77 241 66 04 >> Linkedin: https://www.linkedin.com/in/chaminnalinda >> Web: http://www.ckreativity.com >> Blog: http://techspiro.blogspot.com/ >> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > -- *Chamin Nalinda* Intern - Engineering WSO2 Inc. http://www.wso2.com lean.enterprise.middleware Mobile: (+94) 77 241 66 04 Linkedin: https://www.linkedin.com/in/chaminnalinda Web: http://www.ckreativity.com Blog: http://techspiro.blogspot.com/
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
