Using Lists In Dictionaries

Vertica Pulse supports the use of token-based lists in dictionaries. You can use a list to match multiple terms to a single word. Token based lists differ from mapping by allowing you to create multiple associations in a single action rather than a series of pairs. Unlike mapping, lists are not restricted to the normalization dictionary.

Note: Token-based lists do not apply to the base word in normalization dictionaries.

You can add lists to the following dictionaries:

You can add a token to a user-defined dictionary using an INSERT statement and $LIST parameter containing the list of values to match.

The following example would match slang terms to the word "good".

INSERT INTO pos_words Values( 'good', '$LIST(sweet,dope,tight);