Vertica already provides Text Search. Text Search allows you to quickly search the contents of a single CHAR, VARCHAR, LONG VARCHAR, VARBINARY, or LONG VARBINARY field within a table to locate a specific token.
Vertica implements that capability using a dedicated Text Index to store all the individual tokens from a source table’s text field.
In this blog post, we will explore how to enable sentence (text fragment) or phrase search (consecutive keywords) with a Vertica text index that is configured to track tokens’ position.
Read more about "Phrase Search with Vertica Text Search" here:
https://my.vertica.com/blog/phrase-sear ... xt-search/