1.1 - 8.10 - TextTagger Example: TaggingRules, Superdist - 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 TextTagger (
  ON text_inputs
  USING
  TaggingRules ('superdist(content, "Chennai", "floods", sent, ,)
          AS Chennai-Flood-Disaster',
         'superdist(content, "Roger", "titles", para, "Nadal", para)
          AS Roger-Champion',
         'superdist(content, "Roger", "Nadal", para, ,)
          AS Tennis-Rivalry',
         'contain(content, regex"[A|a]shes", 2,)
          AS Aus-Eng-Cricket',
         'superdist(content, "Australia", "won", nw5, ,)
          AS Aus-victory'
    )
  Accumulate ('id')
) AS dt ORDER BY id;

Output

 id tag                         
 -- --------------------------- 
  1 Chennai-Flood-Disaster     
  2 Roger-Champion             
  3 Tennis-Rivalry             
  4                            
  5 Aus-Eng-Cricket,Aus-victory

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