TextTagger Example: TaggingRules, Dictionary File - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

This example uses this dictionary file, keywords.txt:

floods
tsunamis
Roger
Nadal
India
Pakistan
England
Australia

Input

SQL Call

SELECT * FROM TextTagger (
  ON text_inputs
  USING
  TaggingRules ('dict(content, "keywords.txt", 1,) AND
          equal(titles, "Chennai Floods") AS Natural-Disaster',
         'dict(content, "keywords.txt", 2,) AND
          equal(catalog, "sports") AS Great-Sports-Rivalry '
  )
  Accumulate ('id')
) AS dt ORDER BY id;

Output

 id tag                  
 -- -------------------- 
  1 Natural-Disaster    
  2                     
  3 Great-Sports-Rivalry
  4 Great-Sports-Rivalry
  5 Great-Sports-Rivalry

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