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:
- pos_words
- neg_words
- neutral_words
- normalization
- white_list
- stop_words
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);