HI supun,
you can use the count function and grouping it by Initial_state(group by
Initial_state)
Thanks
On Fri, Nov 14, 2014 at 12:23 PM, Seshika Fernando <sesh...@wso2.com> wrote:
> Why dont you use the sum(Initial_state) function with a group by
> Initial_state?
>
> On Fri, Nov 14, 2014 at 12:12 PM, Supun Muthutantrige <sup...@wso2.com>
> wrote:
>
>> Hii all,
>>
>> There is a mysql table with the following content.
>>
>>
>> The format of the in stream
>>
>> state:HTS
>> state:HFS
>> state:HTM
>> state:HTS
>> state:HTL
>> state:HFS
>> state:MTS
>> state:HTS
>> state:HTL
>> state:MFM
>> state:HTS
>> state:HFS
>>
>>
>> The following siddhi query is used to populate the above table.
>>
>>
>> ----------------------------------------------------------------------------------------------------------------------
>>
>> define table MarkovModel (State_Transition string, Initial_state string,
>> countP double) from ('datasource.name'='FD_ToolBox_DB',
>> 'database.name'='FDtoolbox',
>> 'table.name'='MarkovModel');
>>
>> from every a = inStream -> b = inStream
>> select a.Event as initialState, b.Event as transState,
>> concat(a.Event,b.Event) as StateTransition
>> insert into forCalculation;
>>
>> from forCalculation[((StateTransition!=MarkovModel.State_Transition)
>> in MarkovModel)]
>> select StateTransition, initialState, 1.0 as stateTrans_count
>> insert into insertIntoModel;
>>
>>
>> from forCalculation[((StateTransition==MarkovModel.State_Transition) in
>> MarkovModel)]#window.length(1) join MarkovModel
>> on forCalculation.StateTransition == MarkovModel.State_Transition
>> select StateTransition, initialState, (MarkovModel.countP+1) as
>> updatedState_count
>> insert into updateModel;
>>
>>
>> ----------------------------------------------------------------------------------------------------------------------
>>
>> Want to know how get the total count of *Initial_state*'s from the above
>> table as a continuation to the above query.
>>
>> Ex: HFS - 2
>> HTL - 2
>> HTM - 1
>> HTS - 4
>> MFM - 1
>> MTS - 1
>>
>> Would appreciate any suggestions.
>>
>> 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
>
>
--
Shashika Prabath Karunatilaka,
Software Engineer,
WSO2, Inc: http://wso2.com/
mobile : +94 77 7487792
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
