NerReplace Syntax | Vantage BYOM - NerReplace Syntax - Teradata Vantage

Teradata Vantage™ - Bring Your Own Model User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata Vantage
Release Number
20.00
Published
May 2026
ft:locale
en-US
ft:lastEdition
2026-06-18
dita:mapPath
fee1607120608274.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
fee1607120608274

When ModelTable Contains Only One Model

SELECT * FROM [schema.]NerReplace(
ON { table | view | (query) } as InputTable
ON { table | view | (query) } as ModelTable DIMENSION
ON { table | view | (query) } as ModelConfigTable DIMENSION
ON { table | view | (query) } as TokenizerTable DIMENSION
USING
Accumulate('column'|'columns'|'*') 
	[ ModelOutputTensor(ValidOutputTensorName) ]
	[ ModelOutputFields(modelOutputField|modelOutputFields)  ]
	[ EntitiesToReplace(ValidOutputFormatsList) ]
	[ AggregationStrategy({'NONE'|'SIMPLE'|'AVERAGE'|'FIRST'|'MAX'}) ]
	[ ReplacementText(value) ]
	[ ReplacedEntityInfoLength(Integer) ]
	[ EnableMemoryCheck({'true'|'false'}) ]
	[ IsDebug({'true'|'false'}) ]
) as alias ;

When ModelTable Contains Multiple Models

SELECT * FROM [schema.]NerReplace(
ON { table | view | (query) } as InputTable
ON (SELECT*FROM [table | view | {query}) WHERE model_id = model_identifier) [ AS ModelTable ] DIMENSION
ON { table | view | (query) } as ModelConfigTable DIMENSION
ON { table | view | (query) } as TokenizerTable DIMENSION
USING
Accumulate('column'|'columns'|'*') 
	[ ModelOutputTensor(ValidOutputTensorName) ]
	[ ModelOutputFields(modelOutputField|modelOutputFields)  ]
	[ EntitiesToReplace(ValidOutputFormatsList) ]
	[ AggregationStrategy({'NONE'|'SIMPLE'|'AVERAGE'|'FIRST'|'MAX'}) ]
	[ ReplacementText(value) ]
	[ ReplacedEntityInfoLength(Integer) ]
	[ EnableMemoryCheck({'true'|'false'}) ]
	[ IsDebug({'true'|'false'}) ]
) as alias ;