TD_NERExtractor Function Syntax | Teradata Vantage - TD_NERExtractor Syntax - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
lifecycle
latest
Product Category
Teradata Vantageā„¢
TD_NERExtractor (
  ON { table | view | (query) } as InputTable [ PARTITION BY ANY ]
  [ ON { table | view | (query) } as Dict  DIMENSION ]
  [ ON { table | view | (query) } as Rules DIMENSION ]
  USING
  TextColumn ('text_column')
  [ InputLanguage ('en') ]
  [ ShowContext (context_num) ]
  [ Accumulate ({ 'accumulate_column' | accumulate_column_range }[,...]) ]
)

USING Clause limitation: The maximum number of rules and dictionary words (rows) is allowed to be up to 90% of the available memory of the cluster in use. There is no fixed limit in the number of rows between the two of them.

You can call this function from:
  • The FROM clause of a SELECT statement
  • As part of a CREATE TABLE statement
  • As part of a CREATE VIEW statement