Hi Demini, Firstly, about the error: I don't think it is related to the query. The error could be a result of a session timeout. Do you get this error continuously (even when the session has not expired)?
Secondly, to achieve your requirement, > I want to get the average marks of all students coming from both streams. > , you can use an execution plan like below: from a select meta_name, meta_marks insert into commonStream; from b select meta_name, meta_marks insert into commonStream; from commonStream select meta_name, avg(meta_marks) as avg_marks insert into resultStream; Regards Dilini On Sat, Mar 7, 2015 at 7:08 PM, Demini Indrachapa <[email protected]> wrote: > Hi all, > > I am trying to join two streams and get the data coming from both streams > then do some operation and send it. > > As an example I am getting names and marks from both stream and I want to > get the average marks of all students coming from both streams. The query I > wrote is attached below. > But I got an error as > "The input stream for an incoming message is null." > > Could you please tell me how to correct the query. > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Dilini Muthumala* Software Engineer, WSO2 Inc. *E-mail :* [email protected] *Mobile: *+94 713-400-029
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
