SELECT * FROM HMMDecoder ( ON pi_loyalty AS "InitStateProb" PARTITION BY user_id ON A_loyalty AS "TransProb" PARTITION BY user_id ON B_loyalty AS "EmissionProb" PARTITION BY user_id ON customer_loyalty_newseq AS "observation" PARTITION BY user_id ORDER BY user_id, seq_id, purchase_date ASC InitStateModelColumn ('user_id') InitStateColumn ('state') InitStateProbColumn ('probability') TransAttributeColumn ('user_id') TransFromStateColumn ('from_state') TransToStateColumn ('to_state') TransProbColumn ('probability') EmitModelColumn ('user_id') EmitStateColumn ('state') EmitObsColumn ('observed') EmitProbColumn ('probability') ModelColumn ('user_id') SeqColumn ('seq_id') ObsColumn ('observation') Accumulate ('purchase_date') ) ORDER BY 1, 2, 5;