Synopsis

gpsscli history jobconfig.yaml 
     [--show-commit-history {all | latest}]
     [--config gpsscliconfig.json]
     [--gpss-host host] [--gpss-port port]
     [--no-check-ca] [-l | --log-dir directory] [--verbose]

gpsscli history {-h | --help}

Description

The gpsscli history command displays the commmit history of the job submitted to a Greenplum Streaming Server (GPSS) instance with the specified configuration file. Information displayed includes the start and end times of the load transaction and the beginning and ending data offsets.

You can request the complete commit history or the history for the last batch of data written to Greenplum Database. By default, gpsscli history displays the commit history of the latest data load transaction.

If the GPSS instance to which you want to send the request is not running on the default host (127.0.0.1) or the default port number (5000), you can specify the GPSS host and/or port via command line options.

Options

jobconfig.yaml

The YAML-formatted configuration file that defines the job parameters. If the filename provided is not an absolute path, Greenplum Database assumes the file system location is relative to the current working directory.

--show-commit-history {all | latest}

Specify all to display the complete commit history of the data load operation defined in jobconfig.yaml. latest, the default, prints the commit history of the last batch of data written to Greenplum Database.

--config gpsscliconfig.json

The GPSS configuration file. This file includes properties that identify the gpss instance that services the command. When SSL encryption is enabled between the GPSS client and server, you also use this file to identify the file system location of the client SSL certificates. Refer to gpss.json for detailed information about the format of this file and the configuration properties supported.

Note: gpsscli subcommands read the configuration specified in the ListenAddress block of the gpsscliconfig.json file, and ignore the gpfdist configuration specified in the Gpfdist block of the file.

--gpss-host host

The GPSS host. The default host address is 127.0.0.1. If specified, overrides a ListenAddress:Host value provided in gpsscliconfig.json

--gpss-port port

The GPSS port number. The default port number is 5000. If specified, overrides a ListenAddress:Port value provided in gpsscliconfig.json

--no-check-ca

Disable certificate verification when SSL is enabled between the GPSS client and server. By default, GPSS checks the certificate authority (CA) each time that you invoke a gpsscli subcommand.

-l | --log-dir directory

The directory to which GPSS writes client command log files. GPSS must have write permission to the directory. GPSS creates the log directory if it does not exist.

If you do not provide this option, GPSS writes gpsscli client log files to the $HOME/gpAdminLogs directory.

--verbose

The default behaviour of the command utility is to display information and error messages to stdout. When you specify the --verbose option, GPSS also outputs debug-level messages about the operation.

-h | --help

Show command utility help, and then exit.

Examples

Display the full commit history of the data load operation defined in the configuration file named loadcfg.yaml:

$ gpsscli history --show-commit-history all loadcfg.yaml

See Also

gpss, gpsscli submit, gpsscli.yaml