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. |
