1.1 - 8.10 - SentimentExtractor Example: InputModelFile ('classification:sentimentmodel1.bin') - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

This example uses the model file sentimentmodel1.bin, output by the SentimentTrainer Example.

SQL Call

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

Output

 id out_polarity out_strength 
 -- ------------ ------------ 
  1 POS                     2
  2 POS                     2
  3 POS                     2
  4 POS                     2
  5 POS                     2
  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 from the attachment in the left sidebar.