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