SENTIMENT

SENTIMENT(<COLUMN>): This operation computes a semantic sentiment score for given text. This is an element-wise column operation. The text in each row recieves an independent sentiment score. The sentiment score is real-valued and between -1 and 1. A score greater than zero indicates positive sentiment and a score less than zero indicates a negative sentiment. The strength of the sentiment is reflected in the magnitude (absolute value) of the score. Thus, scores near zero are neutral or close to neutral sentiment.

Syntax

SELECT SENTIMENT(<COLUMN>) FROM <TABLE>;

Args

VARCHAR

The input column containing the text over which sentiment scores are computed.

Examples

SELECT SENTIMENT(review_text) FROM product_reviews_table;

-- Positive sentiment
SELECT SENTIMENT(review_text) AS sent FROM product_reviews_table
WHERE sent > 0.0;

-- Negative sentiment
SELECT SENTIMENT(review_text) AS sent FROM product_reviews_table
WHERE sent < 0.0;

-- Neutral (or close to neutral) sentiment
SELECT SENTIMENT(review_text) AS sent FROM product_reviews_table
WHERE sent < 0.1 AND sent > -0.1;

Introduction

Statements and Ops

Limitations

Syntax

Args

Examples

​Syntax

​Args

​Examples

Syntax

Args

Examples