TextTagger Example: TaggingRules, Superdist - Teradata Vantage

Input

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

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.