URL: http://<db.host>:<db.port>/collect/statistics
Collect statistics for a column(s) in a specified table.
Input Parameter Description
Name | Type | Description |
---|---|---|
table_name | string | Name of a table, in [schema_name.]table_name format, using standard name resolution rules. Must be an existing table. |
column_names | array of strings | List of one or more column names in input parameter table_name for which to collect statistics (cardinality, mean value, etc.). |
options | map of string to strings | Optional parameters. The default value is an empty map ( {} ). |
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:
Name | Type | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
status | String | 'OK' or 'ERROR' | ||||||||||||
message | String | Empty if success or an error message | ||||||||||||
data_type | String | 'collect_statistics_response' or 'none' in case of an error | ||||||||||||
data | String | Empty string | ||||||||||||
data_str | JSON or String | This embedded JSON represents the result of the /collect/statistics endpoint:
Empty string in case of an error. |