SQL-MapReduce Call - Aster Analytics

Teradata AsterĀ® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
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')
);