TextTagger Example 4: TaggingRules, Superdist - Teradata Vantage

Input

• Input table: text_inputs, as in TextTagger Example 1: TaggingRules, Rules

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