TextTagger Example: TaggingRules, Dictionary File | Teradata Vantage - TextTagger Example: TaggingRules, Dictionary File - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.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.