This example uses this dictionary file, keywords.txt:
floods tsunamis Roger Nadal India Pakistan England Australia
Input
- Input table: text_inputs, as in TextTagger Example: TaggingRules
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.