message |
---|
Outputtable "ldaout1" is created successfully. Training converged after 7 iterate steps with delta 4.2582574160277766E-5 There are 20 documents with 520 words in the training set, the perplexity is 92.139160 |
The following query returns the output shown in the following table:
SELECT * FROM ldaout1 ORDER BY docid, topicid;
docid | topicid | topicweight |
---|---|---|
1 | 0 | 0.00442669824335036 |
1 | 1 | 0.00364972124026978 |
1 | 2 | 0.00313760355154859 |
1 | 3 | 0.985083744464884 |
1 | 4 | 0.00370223249994785 |
2 | 0 | 0.00333404274412358 |
2 | 1 | 0.00272130082493761 |
2 | 2 | 0.00322554604431533 |
2 | 3 | 0.986818406648743 |
... | ... | ... |