1.1 - 8.10 - HMMEvaluator 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.8

SELECT * FROM HMMEvaluator (
  ON input_table AS InitialStateProbs PARTITION BY model_key 
  ON state_transition_table AS TransitionProbs PARTITION BY model_key 
  ON emission_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_key_column')
  InitStateColumn ('state_key_column')
  InitStateProbColumn ('init_state_probability')
  TransAttributeColumn ('model_key_column')
  TransFromStateColumn ('from_state_key_column')
  TransToStateColumn ('to_state_key_column')
  TransProbColumn ('trans_probability')
  EmitModelColumn ('model_key_column')
  EmitStateColumn ('state_key_column')
  EmitObsColumn ('observed_key_column')
  EmitProbColumn ('emit_probability')]
  ModelColumn ('model_column')
  SeqColumn ('seq_column')
  ObservationColumn ('observation_column')
  [ Incremental ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
  [ ShowChangeRate ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
  [ SeqProbColumn ('sequence_probability_column') ]
  [ SkipColumn ('skip_key_column') ]
  [ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ]
) AS alias;