The following SQL query generates the probabilities with state information:
DROP TABLE IF EXISTS pi_loyalty; DROP TABLE IF EXISTS A_loyalty; DROP TABLE IF EXISTS B_loyalty; SELECT * FROM HMMSupervisedLearner ( ON customer_loyalty AS "vertices" PARTITION BY user_id, seq_id ORDER BY user_id, seq_id, purchase_date ASC ModelColumn ('user_id') SeqColumn ('seq_id') ObsColumn ('observation') StateColumn ('loyalty_level') OutputTables ('pi_loyalty', 'A_loyalty', 'B_loyalty') );