Page 1 of 1

Phrase Search with Vertica Text Search

Posted: Thu Dec 07, 2017 3:17 pm
by JimKnicely
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: ... xt-search/