Text Analytics and Search

Text Analytics and Search

Greenplum Database offers two different methods for text search and analytics, Greenplum Database full text search and Pivotal GPText.

Greenplum Database Full Text Search

Greenplum Database text search is PostgreSQL text search ported to the Greenplum Database MPP platform. Greenplum Database text search is immediately available to you, with no need to install and maintain additional software. For full details on this topic, see Greenplum Database text search.

Pivotal GPText

For advanced text analysis applications, Pivotal also offers Pivotal GPText, which integrates Greenplum Database with the Apache Solr text search platform. GPText installs an Apache Solr cluster alongside your Greenplum Database cluster and provides Greenplum Database functions you can use to create Solr indexes, query them, and receive results in the database session.

Both of these systems provide powerful, enterprise-quality document indexing and searching services. GPText, with Solr, has many capabilities that are not available with Greenplum Database text search. In particular, GPText is better for advanced text analysis applications. For a comparative between these methods, see Comparing Greenplum Database Text Search with Pivotal GPText.