GetLoadedDictionary

Lists the currently loaded words for the specified user-dictionary.

If the user-dictionary is not loaded, then nothing is returned. You must use the OVER() clause with this function.

Syntax

SELECT GetLoadedDictionary(user-dictionary  [using PARAMETERS language = string][, label='label']) OVER();

Parameters

Argument Description

user-dictionary

The user-dictionary list to retrieve.

Valid values:

  • pos_words
  • neg_words
  • neutral_words
  • stop_words
  • white_list

See Dictionaries and Mappings for details on each type.

language

The language of the dictionary:

  • 'english' or 'en'
  • 'spanish' or 'es'
label The label of the dictionaries that you want to list. If you do not provide a label, Pulse uses the default dictionaries.

Examples

Note: This example is from a three node cluster, so three copies of the words are returned.

SELECT GetLoadedDictionary('pos_words') OVER();       

word ------------------------- :-) adequate admire admiringly adore adoringly adulation adventuresome advocated affable affably affordable affordably afordable all-around alluringly amazement ameliorate ample amusing --More-- SELECT GetLoadedDictionary('pos_words' using PARAMETERS language='english') OVER(); word ------------ simplicity (1 row) SELECT GetLoadedDictionary('pos_words' using PARAMETERS language='spanish') OVER(); word ------------- simplicidad (1 row)

See Also