Input
- ldamodel output table, LDA Example
SQL Call
SELECT * FROM LDATopicSummary ( ON ldamodel PARTITION BY 1 USING OutputByWord ('true') WordWeight ('true') WordCount ('true') ) AS dt ORDER BY topicid, word desc;
Output
topicid word wordweight wordcount ------- -------------- --------------------- --------------------- 0 yh 0.0012392119016443161 0.007183908889594939 0 would 0.03632426938146545 3.0418171296595484 0 work 0.012805555981118114 1.007598743797997 0 without 0.0011682620471686821 0.0010471999637399858 0 wipers 0.04738499167016217 3.998498911420759 0 windshield 0.02437511709534407 2.0082918316503164 0 why 0.0011618165769805538 4.897079896246231E-4 0 while 0.0011756163589425738 0.001683300926031043 0 which 0.0011770753172594952 0.0018094914953010206 0 when 0.024877066430340676 2.051707240845532 0 wheel 0.0011763741779188116 0.0017488474237656875 0 what 0.0011635417929640212 6.389281452263101E-4 ...
Download a zip file of all examples and a SQL script file that creates their input tables.