TextMorph Example 5: TextMorph with POSTagger and TextTagger - Teradata Vantage

This example uses the function POSTagger to create the input table for TextMorph, whose output table is input to the function TextTagger.

POSTagger Input: pos_input

POSTagger SQL Call

CREATE MULTISET TABLE postagger_output AS (
  SELECT * FROM POSTagger (
    ON pos_input
    USING
    Accumulate ('id')
    TextColumn ('txt')
  ) AS dt
) WITH DATA;

POSTagger Output and TextMorph Input: postagger_output

TextMorph SQL Call

CREATE MULTISET TABLE textmorph_output AS (
  SELECT * FROM TextMorph (
    ON postagger_output
    USING
    WordColumn ('word')
    POSTagColumn ('pos_tag')
    Accumulate ('id', 'word_sn', 'word', 'pos_tag')
  ) AS dt
) WITH DATA;

TextMorph Output and TextTagger Input: textmorph_output

This query returns the following table:

SELECT * FROM textmorph_output ORDER BY id, word_sn;

TextTagger SQL Call

SELECT * FROM TextTagger (
  ON textmorph_output
  USING
  TaggingRules('equal(morph, "Australian") as grandslam',
        'equal(morph, "wimbledon") as grandslam',
        'equal(morph, "USOpen") as grandslam',
        'equal(morph, "FrenchOpen") as grandslam')
  Accumulate ('id', 'word_sn', 'morph')
) AS dt ORDER BY id, word_sn;

TextTagger Output