LDATopicSummary Example: OutputByWord ('false') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

Input

SQL Call

SELECT * FROM LDATopicSummary (
  ON ldamodel PARTITION BY 1
  USING
  OutputByWord ('false')
  OutputTopicWordNum (10)
) AS dt ORDER BY topicid;

Output

 topicid wordsequence                                                               
 ------- -------------------------------------------------------------------------- 
       0 wipers,would,switch,when,on,recall,windshield,notified,manufacturer,dealer
       1 vehicle,causing,consumer,replaced,which,module,out,control,has,at         
       2 vehicle,manufacturer,would,transmission,problem,when,at,has,also,&        
       3 did,not,deploy,hit,vehicle,side,air,passenger's,bags,mph                  
       4 vehicle,side,car,engine,while,fire,for,from,left,wheel

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.