SQL-MapReduce Call - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

Assume that there are three hidden states to train the models and use the default method, random. The query outputs three state tables: pi_loan (initial state probabilities), A_loan (state transition probabilities) and B_loan (emission, or observation, probabilities).

DROP TABLE IF EXISTS pi_loan;
DROP TABLE IF EXISTS A_loan;
DROP TABLE IF EXISTS B_loan;

SELECT * FROM HMMUnsupervisedLearner (
  ON loan_prediction AS "vertices"
  PARTITION BY model_id, seq_id ORDER BY seq_vertex_id
  ModelColumn ('model_id')
  SeqColumn ('seq_id')
  ObsColumn ('observed_id')
  HiddenStateNum ('3')
  InitMethods ('random')
  OutputTables ('pi_loan', 'A_loan', 'B_loan')
);