1.0 - 8.00 - TextTagger Example 4: TaggingRules, Superdist - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
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