GetAllDictionaryWords
Lists all dictionary words that are currently loaded into Pulse. This function can help you determine which user-defined words in a sentence might be affecting the sentiment score of an attribute.
Syntax
SELECT GetAllDictionaryWords([using PARAMETERS language='language'[, label='label']) OVER();
Parameters
Argument | Description |
---|---|
language |
The language of the dictionary:
|
label | The label of the dictionaries that you want to list. If you do not provide a label, Pulse uses the default dictionaries. |
Examples
SELECT GetAllDictionaryWords() OVER();
dictionary | word ------------+------------- neg_words | ratchet neg_words | squirelly
select GetAllDictionaryWords(using parameters language='english') over(); dictionary | word -------------------+------------ pos_words_en | simplicity (1 row) select GetAllDictionaryWords(using parameters label='music') over(); dictionary | word -------------------+------------- white_list_en | classical white_list_en | popular white_list_en | rock (3 rows)