Phrase Search with Vertica Text Search

Moderator: NorbertKrupa

Post Reply
User avatar
Site Admin
Site Admin
Posts: 1824
Joined: Sat Jan 21, 2012 4:58 am

Phrase Search with Vertica Text Search

Post by JimKnicely » Thu Dec 07, 2017 3:17 pm

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/
Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”