GetAllMappingWords
Lists all user-defined bases and synonyms that are currently loaded into Pulse. This function helps you determine which user-defined mappings in a sentence might be affecting the sentiment score of an attribute.
Syntax
SELECT GetAllMappingWords([using PARAMETERS language='language'][, label='label']) OVER();
Parameters
Argument | Description |
---|---|
language |
The language of the dictionary:
|
label | The label of the mappings that you want to list. If you do not provide a lable, Pulse uses the default dictionaries. |
Examples
SELECT GetAllMappingWords() OVER() limit 10; mapping | key | value ---------------+-------------+----------------- normalization | hp | hewlett packard normalization | hp | hewlett-packard normalization | companycorp | company-corp normalization | companycorp | companycorps normalization | companycorp | companycorp's normalization | producthd | product hd normalization | producthd | product-hd normalization | companycorp | company corp (8 rows)
select getAllMappingWords(using parameters language='english') over(); mapping | key | value -----------------------+-----+----------------- normalization_en | hp | hewlett-packard normalization_en | hp | hewlett Packard (2 rows) select getAllMappingWords(using parameters language='spanish') over(); mapping | key | value -----------------------+---------+---------------- normalization_es | hidalgo | miguel hidalgo (1 row)