The gptext schema includes tables that VMware Greenplum Text uses to manage the VMware Greenplum Text cluster and to log VMware Greenplum Text activities.

gptext.admin_history

VMware Greenplum Text writes a record to the gptext.admin_history table when the following actions occur:

  • create or drop a VMware Greenplum Text index
  • add or drop a field in a VMware Greenplum Text index
  • back up or restore a VMware Greenplum Text index
  • add or remove a ZooKeeper role on a VMware Greenplum Text node
Column Type Description
time timestamp without time zone The time the action occurred.
user character varying(64) The name of the VMware Greenplum 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 VMware Greenplum Text environment variables. Currently, the only VMware Greenplum Text environment variable is $GPTXTHOME, which is the VMware Greenplum Text installation directory. The source for the rows in this table is the CSV file $MASTER_DATA_DIRECTORY/gptxtenvs.conf on the master host and the standby master host.

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

gptext.error_table

VMware Greenplum Text writes a record in the gptext.error_table when a request to add a document to a VMware Greenplum Text 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. The source for the rows in this table is the CSV file $MASTER_DATA_DIRECTORY/gptext.conf on the master host and the standby master host.

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. The source for the rows in this table is the CSV file $MASTER_DATA_DIRECTORY/zookeeper.conf on the master host and the standby master host.

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.
check-circle-line exclamation-circle-line close-line
Scroll to top icon