LATEST VERSION: 2.3.1 - CHANGELOG
Pivotal® Greenplum® Text v2.2.1

GPText Schema Tables

The gptext schema includes tables that GPText uses to manage the GPText cluster and to log GPText activities.

gptext.admin_history

GPText writes a record to the gptext.admin_history table when the following actions occur:

  • create or drop a GPText index
  • add or drop a field in a GPText index
  • back up or restore a GPText index
  • add or remove a ZooKeeper role on a GPText node
Column Type Description
time timestamp without time zone The time the action occurred.
user character varying(64) The name of the Greenplum Database role that performed the action.
action text A text message describing the action.

gptext.gptext_envs

The gptext.gptext_envs table is an external table containing rows with values for GPText environment variables. Currently, the only GPText environment variable is $GPTXTHOME, which is the GPText installation directory. The source for the rows in this table is the CSV file $MASTER_DATA_DIRECTORY/gptxtenvs.conf.

Column Type Description
envname text The name of an environment variable.
value text The value of the environment varialbe.

gptext.error_table

GPText writes a record in the gptext.error_table when a request to add a document to a GPText external index fails. Rows remain in the table until you call gptext.recreate_error_table to drop and recreate the table.

Column Type Description
error_time timestamp without time zone The time the error occurred.
index_name text The name of the external index.
sqlcmd text Text of the SQL statement, if any.
errmsg text The message text of the error that occurred.
rawdata text Data associated with the error, for example the document URL.
rawbytes bytea Binary data associated with the error, if any.

gptext.solr_instances

The gptext.solr_instances table is an external table with a row for each Solr instance.

Column Type Description
id integer Unique id for the Solr instance.
host text Name of the host where the instance is running.
port integer Port number of the Solr instance.
solrdir text Path to the Solr instance’s data directory.
zoocluster text A list of ZooKeeper nodes.

gptext.zoo_cluster

The gptext.zoo_cluster is an external table with one row for each ZooKeeper node.

Column Type Description
id integer The unique id of the ZooKeeper node.
host text Name of the host where the ZooKeeper node is running.
port integer Port number of the ZooKeeper instance.
data_directory text Path to the Zookeeper node’s data directory.