NerReplace Example: Loading Model with BTEQ - Teradata Vantage

-- load generated model using BTEQ client


-- Make sure that the model table "mleap_models" exists and has two columns: model_id as "varchar" and model as "BLOB" type
-- Create a file load_mleap_model.txt that has a model_id and a model file name entry such as:
-- dr_iris_rf|dr_iris_rf.zip

.import vartext file ./load_embeddings_tokenizer.txt

.repeat *
USING (c1 VARCHAR(40), c2 BLOB AS DEFERRED BY NAME) INSERT INTO ner_tokenizers_tst(:c1, :c2);

.import vartext file ./load_embeddings_config.txt

.repeat *
USING (c1 VARCHAR(40), c2 BLOB AS DEFERRED BY NAME) INSERT INTO ner_model_configurations_tst(:c1, :c2);