1.0 - 8.00 - TextMorph Example 1: SingleOutput ('true') - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

Input

words_input
id word
1 regression
2 Roger
3 better
4 datum
5 quickly
6 proud
7 father
8 juniors
9 doing
10 being
11 negating
12 yearly

SQL Call

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

Output

id word morph pos
1 regression regression noun
2 Roger Roger  
3 better good adj
4 datum datum noun
5 quickly quickly adv
6 proud proud adj
7 father father noun
8 juniors junior noun
9 doing do verb
10 being be verb
11 negating negate verb
12 yearly yearly noun