1.1 - 8.10 - LDATopicSummary Example: OutputByWord ('false') - 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 ('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.