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

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.