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:

  • 'english' or 'en'
  • 'spanish' or 'es'
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)

See Also