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