sorry I didnt read your entire message. So whats the error you get when you use group by statement?
On Fri, Nov 14, 2014 at 1:56 PM, Seshika Fernando <sesh...@wso2.com> wrote: > You have to use *group by initialState* after the select statement > > On Fri, Nov 14, 2014 at 1:19 PM, Supun Muthutantrige <sup...@wso2.com> > wrote: > >> Hi seshika, >> >> Yes tried that but it doesn't give the desired output. >> >> The query that we have used as follows, >> >> from forCalculation#window.length(1) join MarkovModel >> on forCalculation.initialState == MarkovModel.Initial_state >> select initialState as Event, sum(MarkovModel.countP) as totalCount >> insert into ckStream; >> >> this was tried using group by as well, Still it doesn't give the result >> >> any thoughts? >> >> Thank you >> Regards >> >> *Supun Rasitha Muthutantrige* >> Software Engineer | Intern >> WSO2 Inc: http://wso2.com >> lean.enterprise.middleware >> Mobile: 0758374608 >> > >
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev