SentimentExtractor Example | Teradata Vantage - SentimentExtractor Example: InputModelFile ('classification:default_sentiment_classification_model.bin') - Teradata Vantage

This example uses the maximum entropy classification model file default_sentiment_classification_model.bin.

Input

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

SQL Call

SELECT * FROM SentimentExtractor (
  ON sentiment_extract_input
  USING
  TextColumn ('review')
  InputModelFile ('classification:default_sentiment_classification_model.bin')
  AnalysisType ('document')
  Accumulate ('id')
) AS dt ORDER BY id;

Output

 id out_polarity out_strength 
 -- ------------ ------------ 
  1 NEG                     2
  2 POS                     2
  3 NEG                     2
  4 POS                     2
  5 POS                     1
  6 NEG                     2
  7 NEG                     2
  8 NEG                     2
  9 NEG                     2
 10 NEG                     2

Download a zip file of all examples and a SQL script file that creates their input tables.