1.1 - 8.10 - HMMDecoder Syntax - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Version 1.9

SELECT * FROM HMMDecoder (
  ON init_prob_table AS InitialStateProbs PARTITION BY model_key [ ORDER BY model_key, state_key_column ] 
  ON trans_prob_table AS TransitionProbs PARTITION BY model_key 
  ON emission_prob_table AS EmissionProbs PARTITION BY model_key 
  ON observation_table AS ObservationTable 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')
  ObservationColumn ('observation_column')
  [ SequenceMaxSize ('range') ]
  [ SkipColumn ('skip_column') ]
  [ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ]
) AS alias;