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 1: TaggingRules, Rules
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 |