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.
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.