TextMorph Example 3: POS ('noun', 'verb'), SingleOutput ('false') - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.00
1.0
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

Input

SQL Call

SELECT * FROM TextMorph (
  ON words_input
  USING
  WordColumn ('word')
  SingleOutput ('false')
  POS ('noun', 'verb')
  Accumulate ('id', 'word')
) AS dt ORDER BY id;

Output

For the input word better, the function does not find noun and verb morphs. However, the function finds better in the dictionary as both a noun and a verb, so it outputs those.

With SingleOutput ('false'), the words better and father appear in the output table as both nouns and verbs.

id word morph pos
1 regression regression noun
3 better better noun
3 better better verb
4 datum datum noun
7 father father noun
7 father father verb
8 juniors junior noun
9 doing do verb
10 being be verb
11 negating negate verb
12 yearly yearly noun