TD_NERExtractor Output - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢
Column Name Data Type Description
Accumulate columns ANY Columns copied from input to output.
sn INTEGER Match number in a given row.
entity VARCHAR CHARACTER SET LATIN

VARCHAR CHARACTER SET UNICODE

Matched string for a given dictionary word or regex pattern. Column size is fixed to 1000 characters (UNICODE and LATIN). Character set will be the same as input tables.
type VARCHAR CHARACTER SET LATIN

VARCHAR CHARACTER SET UNICODE

User-defined entity name (tag/label) for matched dictionary word or regex pattern. Column size will be the largest of type_ner columns from rules or dict table. Character set will be the same as input tables.
start INTEGER Word number in row where the match starts.
end INTEGER Word number in row where the match ends.
context VARCHAR CHARACTER SET LATIN

VARCHAR CHARACTER SET UNICODE

[Optional] Only appears when argument ShowContext > 0 is passed. Column size will be the same as TextColumn, up to 16000 characters (UNICODE or LATIN), whichever is smaller. Character set will be the same as input tables.
approach VARCHAR CHARACTER SET LATIN

VARCHAR CHARACTER SET UNICODE

Category of matched string RULE for regex rules, or DICT for dictionary word.

Column size if 4 characters fixed (UNICODE or LATIN). Character set will be the same as input tables.