/show/proc

URL: https://<aws.fqdn>/<aws.cluster.name>/gpudb-0/show/proc

Shows information about a proc.

Input Parameter Description

NameTypeDescription
proc_namestringName of the proc to show information about. If specified, must be the name of a currently existing proc. If not specified, information about all procs will be returned. The default value is ''.
optionsmap of string to strings

Optional parameters. The default value is an empty map ( {} ).

Supported Parameters (keys)Parameter Description
include_files

If set to true, the files that make up the proc will be returned. If set to false, the files will not be returned. The default value is false. The supported values are:

  • true
  • false

Output Parameter Description

The GPUdb server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query. Here is a description of the various fields of the wrapper:

NameTypeDescription
statusString'OK' or 'ERROR'
messageStringEmpty if success or an error message
data_typeString'show_proc_response' or 'none' in case of an error
dataStringEmpty string
data_strJSON or String

This embedded JSON represents the result of the /show/proc endpoint:

NameTypeDescription
proc_namesarray of stringsThe proc names.
execution_modesarray of strings

The execution modes of the procs named in output parameter proc_names.

Possible List EntriesDescription
string
Possible ValuesDescription
distributedDistributed
nondistributedNondistributed
filesarray of maps of string to bytesMaps of the files that make up the procs named in output parameter proc_names.
commandsarray of stringsThe commands (excluding arguments) that will be invoked when the procs named in output parameter proc_names are executed.
argsarray of arrays of stringsArrays of command-line arguments that will be passed to the procs named in output parameter proc_names when executed.
optionsarray of maps of string to stringsThe optional parameters for the procs named in output parameter proc_names.
infomap of string to stringsAdditional information.

Empty string in case of an error.