message |
---|
There are 10 valid documents with 153 recognized words in the input, the perplexity is 145.758867 Outputtable "ldaout2" is created successfully. |
The following query returns the output shown in the following table:
SELECT * FROM ldaout2 ORDER BY docid, topicid;
docid | topicid | topicweight | topicwords |
---|---|---|---|
1 | 0 | 0.00421317772559819 | wipers,would,switch,when,on |
1 | 1 | 0.982025483899112 | vehicle,causing,consumer,replaced,which |
1 | 2 | 0.00449350162478127 | vehicle,manufacturer,would,transmission,when |
1 | 3 | 0.00431128170088637 | did,not,deploy,hit,vehicle |
1 | 4 | 0.0049565550496219 | vehicle,side,car,engine,while |
2 | 0 | 0.237979551143677 | wipers,would,switch,when,on |
2 | 1 | 0.0131031974444299 | vehicle,causing,consumer,replaced,which |
2 | 2 | 0.0980050092051074 | vehicle,manufacturer,would,transmission,when |
2 | 3 | 0.6322490967996 | did,not,deploy,hit,vehicle |
2 | 4 | 0.0186631454071852 | vehicle,side,car,engine,while |
... | ... | ... | ... |