Creating Tables for Custom Dictionary Mappings
The Vertica Pulse package includes all the necessary user dictionary and mappings tables. However, you can create your own tables to store additional user dictionaries or mappings. For example:
CREATE TABLE my_positive_words(word VARCHAR(64));
The following example shows how to create a table, add terms to it, and then load the table as a normalization map:
=> CREATE TABLE myNormalization(base VARCHAR(64), synonym VARCHAR(64));
=> INSERT INTO myNormalization VALUES('hp','Hewlett Packard'); => INSERT INTO myNormalization VALUES('hp','Hewlett-Packard');
=> COMMIT;
=> SELECT LoadMapping(base, synonym USING PARAMETERS
mapName='normalization') OVER() FROM myNormalization;
After loading, Vertica returns a success message from each node in the cluster.