NERExtractor Example - Teradata Vantage

Input

• Input table: ner_sports_test2, which contains text to analyze.
• Rules table: rule_table, which is preinstalled on the ML Engine.
• Model file: ner_model.bin, output by NERTrainer Example.

SQL Call

SELECT * FROM NERExtractor (
  ON ner_sports_test2 PARTITION BY ANY
  ON rule_table AS rules DIMENSION
  USING
  TextColumn ('content')
  ModelFiles ('ner_model.bin')
  ShowContext (2)
  Accumulate ('id')
) AS dt ORDER BY id, sn;

Output