1.1 - 8.10 - NERTrainer Example - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

Input

  • Input table: ner_sports_train, a collection of sports news items (500 rows)
  • Feature template file: template_1.txt, which is preinstalled on ML Engine.
ner_sports_train
id content
2 CRICKET - <START:ORG> LEICESTERSHIRE <END> TAKE OVER AT TOP AFTER INNINGS VICTORY .
3 <START:LOC> LONDON <END> 1996-08-30
4 West Indian all-rounder <START:PER> Phil Simmons <END> took four for 38 on Friday as <START:ORG> Leicestershire <END> beat <START:ORG> Somerset <END> by an innings and 39 runs in two days to take over at the head of the county championship .
5 Their stay on top
6 After bowling <START:ORG> Somerset <END> out for 83 on the opening morning at <START:LOC> Grace Road <END>
7 Trailing by 213
8 <START:ORG> Essex <END>
9 <START:PER> Hussain <END>
10 By the close <START:ORG> Yorkshire <END> had turned that into a 37-run advantage but off-spinner <START:PER> Such <END> had scuttled their hopes
... ...

SQL Call

SELECT * FROM NERTrainer (
  ON ner_sports_train PARTITION BY 1
  USING
  TextColumn ('content')
  FeatureTemplate ('template_1.txt')
  OutputModelFile ('ner_model.bin')
) AS dt;

Output

 train_result                  
 ----------------------------- 
 Model generated.             
 Training time(s): 3.129      
 File size(KB): 374           
 Model successfully installed.

The model file, ner_model.bin, is in binary format.

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.