SentimentExtractor Example 2: ModelFile ('dictionary'), AnalysisType ('sentence') - Teradata Vantage

This example uses the dictionary model file default_sentiment_lexicon.txt.

Input

• Input table: sentiment_extract_input, as in SentimentExtractor Example 1: ModelFile ('dictionary'), AnalysisType ('document')

SQL Call

SELECT * FROM SentimentExtractor (
  ON sentiment_extract_input
  USING
  TextColumn ('review')
  ModelFile ('dictionary')
  AnalysisType ('sentence')
  Accumulate ('id', 'product')
) AS dt ORDER BY id;

Output