Using Full Text Search

Greenplum Database provides data types, functions, operators, index types, and configurations for querying natural language documents.

  • About Full Text Search
    This topic provides an overview of Greenplum Database full text search, basic text search expressions, configuring, and customizing text search. Greenplum Database full text search is compared with Pivotal GPText.
  • Searching Text in Database Tables
    This topic shows how to use text search operators to search database tables and how to create indexes to speed up text searches.
  • Controlling Text Search
    This topic shows how to create search and query vectors, how to rank search results, and how to highlight search terms in the results of text search queries.
  • Additional Text Search Features
    Greenplum Database has additional functions and operators you can use to manipulate search and query vectors, and to rewite search queries.
  • Text Search Parsers
    This topic describes the types of tokens the Greenplum Database text search parser produces from raw text.
  • Text Search Dictionaries
    Tokens produced by the Greenplum Database full text search parser are passed through a chain of dictionaries to produce a normalized term or “lexeme”. Different kinds of dictionaries are available to filter and transform tokens in different ways and for different languages.
  • Text Search Configuration Example
    This topic shows how to create a customized text search configuration to process document and query text.
  • Testing and Debugging Text Search
    This topic introduces the Greenplum Database functions you can use to test and debug a search configuration or the individual parser and dictionaries specified in a configuration.
  • GiST and GIN Indexes for Text Search
    This topic describes and compares the Greenplum Database index types that are used for full text searching.
  • psql Support
    The psql command-line utility provides a meta-command to display information about Greenplum Database full text search configurations.
  • Limitations
    This topic lists limitations and maximums for Greenplum Database full text search objects.

Parent topic: Querying Data

Need help? Visit the Greenplum Database Community