1.1 - 8.10 - LDATopicSummary Example: WordWeight ('true'), WordCount ('true') - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

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 from the attachment in the left sidebar.