The rules table, rule_inputs, defines the same rules as the TaggingRules argument in Example 1.
Input
- Input table: text_inputs, as in TextTagger Example 1: TaggingRules, Rules
- rules: rule_inputs
| tagname | definition |
|---|---|
| Cricket-Rivalry | contain(content,"India",1,) and contain(content,"Pakistan",1,) |
| Natural-Disaster | contain(content, "floods",1,) or contain(content,"tsunamis",1,) |
| Tennis-Greats | contain(titles,"Tennis",1,) and contain(content,"Roger",1,) |
| Tennis-Rivalry | contain(content,"Roger",1,) and contain(content,"Nadal",1,) |
| The-Ashes | contain(content,"Australia",1,) and contain(content,"England",1,) |
SQL Call
SELECT * FROM TextTagger (
ON text_inputs PARTITION BY ANY
ON rule_inputs AS rules DIMENSION
USING
Accumulate ('id')
) AS dt ORDER BY id;
Output
| id | tag |
|---|---|
| 1 | Natural-Disaster |
| 2 | Tennis-Greats |
| 3 | Tennis-Rivalry |
| 4 | Cricket-Rivalry |
| 5 | The-Ashes |