Before calling the FindNamedEntity function, you must create the table of default models. To create the table, use this command:
CREATE DIMENSION TABLE nameFind_configure ( model_entitytype VARCHAR, model_method VARCHAR, model_file VARCHAR);
Default English-language models are provided with the SQL-MapReduce functions. Before using these models, you must install them (using the \install command in ACT) and create a default configure_table, as follows:
DROP TABLE IF EXISTS nameFind_configure; CREATE DIMENSION TABLE nameFind_configure (model_name VARCHAR, model_type VARCHAR, model_file VARCHAR); INSERT INTO nameFind_configure VALUES ('person','max entropy','en-ner-person.bin'); INSERT INTO nameFind_configure VALUES ('location','max entropy','en-ner-location.bin'); INSERT INTO nameFind_configure VALUES ('organization','max entropy','en-ner-organization.bin'); INSERT INTO nameFind_configure VALUES ('date','rules','date.rules'); INSERT INTO nameFind_configure VALUES ('time','rules','time.rules'); INSERT INTO nameFind_configure VALUES ('phone','rules','phone.rules'); INSERT INTO nameFind_configure VALUES ('money','rules','money.rules'); INSERT INTO nameFind_configure VALUES ('email','rules','email.rules'); INSERT INTO nameFind_configure VALUES ('percentage','rules','percentage.rules'); \install evaluatenamedentityfinderpartition.zip \install evaluatenamedentityfinderrow.zip \install findnamedentity.zip \install trainnamedentityfinder.zip \install nameFinderModel/date.rules \install nameFinderModel/time.rules \install nameFinderModel/en-sent.bin \install nameFinderModel/email.rules \install nameFinderModel/email.bin \install nameFinderModel/en-ner-location.bin \install nameFinderModel/percentage.rules \install nameFinderModel/en-token.bin \install nameFinderModel/names.txt \install nameFinderModel/en-ner-organization.bin \install nameFinderModel/money.rules \install nameFinderModel/en-ner-person.bin \install nameFinderModel/phone.rules \install nameFinderModel/country.txt
model_name | model_type | model_file |
---|---|---|
person | max entropy | en-ner-person.bin |
location | max entropy | en-ner-location.bin |
organization | max entropy | en-ner-organization.bin |
date | rules | date.rules |
time | rules | time.rules |
phone | rules | phone.rules |
money | rules | money.rules |
rules | email.rules | |
percentage | rules | percentage.rules |