Version 1.9
SELECT * FROM HMMDecoder (
ON init_prob_table AS InitStateProb PARTITION BY model_key [ ORDER BY model_key, state_key_column ]
ON trans_prob_table AS TransProb PARTITION BY model_key
ON emission_prob_table AS EmissionProb PARTITION BY model_key
ON observation_table AS observation PARTITION BY model_key
ORDER BY time_ordered_sequence_column ASC [,...]
USING
InitStateModelColumn ('model_column')
InitStateColumn ('state_key_column')
InitStateProbColumn ('init_state_probability')
TransAttributeColumn ('model_column')
TransFromStateColumn ('from_state_key_column')
TransToStateColumn ('to_state_key_column')
TransProbColumn ('trans_probability')
EmitModelColumn ('model_column')
EmitStateColumn ('state_key_column')
EmitObsColumn ('observed_key_column')
EmitProbColumn ('emit_probability')]
ModelColumn ('model_column')
SeqColumn ('seq_column')
ObsColumn ('observed_column')
[ SequenceMaxSize ('range') ]
[ SkipColumn ('skip_column') ]
[ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ]
) AS alias;