Adds a host to an existing cluster.

Add one or more ranks to an existing Kinetica cluster.

Alter properties on an existing host in the cluster.

Perform the requested action on a list of one or more job(s).

Prepares the system for a backup by closing all open file handles after allowing current active jobs to complete.

Restores the system to normal operating mode after a backup has completed, allowing any queries that were blocked to complete.

Pauses consumption of messages from other HA clusters to support data repair/recovery scenarios.

Restarts the HA processing on the given cluster as a mechanism of accepting breaking HA conf changes.

Take the system offline.

Rebalance the data in the cluster so that all nodes contain an equal number of records approximately and/or rebalance the shards to be equally distributed (as much as possible) across all the ranks.

Removes a host from an existing cluster.

Remove one or more ranks from an existing Kinetica cluster.

Manually repair a corrupted table.

Sends a user generated alert to the monitoring system.

Requests a list of the most recent alerts.

Requests the detailed status of the current operation (by default) or a prior cluster operation specified by historyIndex.

Get a list of the current jobs in GPUdb.

Show the mapping of shards to the corresponding rank and tom.

Exits the database server application.

Manually switch over one or more processes to another host.

Verify database is in a consistent state.

Calculates and returns the convex hull for the values in a table specified by tableName.

Calculates unique combinations (groups) of values for the given columns in a given table or view and computes aggregates on each unique combination.

Performs a histogram calculation given a table, a column, and an interval function.

This endpoint runs the k-means algorithm - a heuristic algorithm that attempts to do k-means clustering.

Calculates and returns the minimum and maximum values of a particular column in a table.

Calculates and returns the minimum and maximum x- and y-coordinates of a particular geospatial geometry column in a table.

Calculates the requested statistics of the given column(s) in a given table.

Divides the given set into bins and calculates statistics of the values of a value-column in each bin.

Returns all the unique values from a particular column (specified by columnName) of a particular table or view (specified by tableName).

Returns all the unique values from a particular column (specified by columnName) of a particular table or view (specified by tableName).

Rotate the column values into rows values.

Alters an existing database backup, accessible via the data sink specified by datasinkName.

Alter the properties of an existing credential.

Alters the properties of an existing data sink.

Alters the properties of an existing data source.

Alters an existing directory in KiFS.

Alters an existing environment which can be referenced by a user-defined function (UDF).

Alters the properties of an existing resource group to facilitate resource management.

Alters a Role.

Used to change the name of a SQL-style schema, specified in schemaName.

The alterSystemProperties endpoint is primarily used to simplify the testing of the system and is not expected to be used during normal execution.

Apply various modifications to a table or view.

Apply various modifications to columns in a table, view.

Updates (adds or changes) metadata for tables.

Alters a table monitor previously created with createTableMonitor.

Alters properties of an existing tier to facilitate resource management.

Alters a user.

Alters a video.

Alters table write-ahead log (WAL) settings.

Append (or insert) all records from a source table (specified by sourceTableName) to a particular target table (specified by tableName).

Scans the requested tables as specified in tableNames for integrity.

Clears statistics (cardinality, mean value, etc.) for a column in a specified table.

Clears (drops) one or all tables in the database cluster.

Deactivates a table monitor previously created with createTableMonitor.

Clears (drops) tables in the database cluster.

Clears or cancels the trigger identified by the specified handle.

Collect statistics for a column(s) in a specified table.

Creates a database backup, containing a snapshot of existing objects, at the remote file store accessible via the data sink specified by datasinkName.

Creates a catalog, which contains the location and connection information for a deltalake catalog that is external to the database.

Create a new credential.

Creates a data sink, which contains the destination information for a data sink that is external to the database.

Creates a data source, which contains the location and connection information for a data store that is external to the database.

Creates a new directory in KiFS.

Creates a new environment which can be used by user-defined functions (UDF).

Creates a new graph network using given nodes, edges, weights, and restrictions.

Create a job which will run asynchronously.

Creates a table that is the result of a SQL JOIN.

Initiates the process of creating a materialized view, reserving the view’s name to prevent other views or tables from being created with that name.

Creates an instance (proc) of the user-defined functions (UDF) specified by the given command, options, and files, and makes it available for execution.

Creates a new projection of an existing table.

Creates a new resource group to facilitate resource management.

Creates a new role.

Creates a SQL-style schema.

Creates a new table with the given type (definition of columns).

Creates a new external table, which is a local database object whose source data is located externally to the database.

Creates a monitor that watches for a single table modification event type (insert, update, or delete) on a particular table (identified by tableName) and forwards event notifications to subscribers via ZMQ.

Sets up an area trigger mechanism for two column_names for one or more tables.

Sets up a simple range trigger for a column_name for one or more tables.

Creates a new type describing the columns of a table.

Merges data from one or more tables with comparable data types into a new table.

Creates a new external user (a user whose credentials are managed by an external LDAP).

Creates a new internal user (a user whose credentials are managed by the database system).

Creates a job to generate a sequence of raster images that visualize data over a specified time.

Deletes a directory from KiFS.

Deletes one or more files from KiFS.

Deletes an existing graph from the graph server and/or persist.

Deletes a proc.

Deletes record(s) matching the provided criteria from the given table.

Deletes a resource group.

Deletes an existing role.

Deletes an existing user.

Downloads one or more files from KiFS.

Deletes one or more existing database backups and contained snapshots, accessible via the data sink specified by datasinkName.

Drops an existing catalog.

Drop an existing credential.

Drops an existing data sink.

Drops an existing data source.

Drop an existing user-defined function (UDF) environment.

Drops an existing SQL-style schema, specified in schemaName.

Executes a proc.

Execute a SQL statement (query, DML, or DDL).

Execute a SQL statement (query, DML, or DDL).

Export query metrics to a given destination.

Export records from a table to files.

Exports records from source table to the specified target table in an external database.

Filters data based on the specified expression.

Calculates which objects from a table are within a named area of interest (NAI/polygon).

Calculates which geospatial geometry objects from a table intersect a named area of interest (NAI/polygon).

Calculates how many objects within the given table lie in a rectangular box.

Calculates which geospatial geometry objects from a table intersect a rectangular box.

Applies a geometry filter against a geospatial geometry column in a given table or view.

Calculates which records from a table have values in the given list for the corresponding column.

Calculates which objects from a table lie within a circle with the given radius and center point (i.e. circular NAI).

Calculates which geospatial geometry objects from a table intersect a circle with the given radius and center point (i.e. circular NAI).

Calculates which objects from a table have a column that is within the given bounds.

Filters objects matching all points of the given track (works only on track type data).

Calculates which objects from a table or view match a string expression for the given string columns.

Filters objects in one table based on objects in another table.

Calculates which objects from a table has a particular value for a particular column.

Retrieves node or edge entities from an existing graph, with pagination support via offset and limit.

Get the status and result of asynchronously running job.

Retrieves records from a given table, optionally filtered by an expression and/or sorted by a column.

Retrieves records from a given table, optionally filtered by an expression and/or sorted by a column.

For a given table, retrieves the values from the requested column(s).

Retrieves the complete series/track records from the given worldTableName based on the partial track information contained in the tableName.

Retrieves the complete series/track records from the given worldTableName based on the partial track information contained in the tableName.

Retrieves the complete series/track records from the given worldTableName based on the partial track information contained in the tableName.

Retrieves records from a collection.

Retrieves records from a collection.

Retrieves records from a given table, optionally filtered by an expression and/or sorted by a column.

Grant user or role the specified permission on the specified object.

[DEPRECATED—please use grantPermission instead] Grants a credential-level permission to a user or role.

[DEPRECATED—please use grantPermission instead] Grants a data source permission to a user or role.

[DEPRECATED—please use grantPermission instead] Grants a KiFS directory-level permission to a user or role.

[DEPRECATED—please use grantPermission instead] Grants a proc-level permission to a user or role.

[DEPRECATED—please use grantPermission instead] Grants a system-level permission to a user or role.

[DEPRECATED—please use grantPermission instead] Grants a table-level permission to a user or role.

Grants membership in a role to a user or role.

Checks if the specified user has the specified permission on the specified object.

Checks the existence of a proc with the given name.

Checks if the specified user has the specified role.

Checks for the existence of a schema with the given name.

Checks for the existence of a table with the given name.

Check for the existence of a type.

Adds multiple records to the specified table.

Adds multiple records to the specified table.

Reads from one or more files and inserts the data into a new or existing table.

Reads from the given text-based or binary payload and inserts the data into a new or existing table.

Computes remote query result and inserts the result data into a new or existing table.

Generates a specified number of random records and adds them to the given table.

Adds a symbol or icon (i.e. an image) to represent data points when data is rendered visually.

Kills a running proc instance.

Manages global access to a table’s data.

Matches a directed route implied by a given set of latitude/longitude points to an existing underlying road network graph using a given solution type.

Update an existing graph network using given nodes, edges, weights, restrictions, and options.

Employs a topological query on a graph generated a-priori by createGraph and returns a list of adjacent edge(s) or node(s), also known as an adjacency list, depending on what’s been provided to the endpoint; providing edges will return nodes and providing nodes will return edges.

Rebalances an existing partitioned graph.

Restores database objects from a backup accessible via the data source specified by datasourceName.

Revoke user or role the specified permission on the specified object.

[DEPRECATED—please use revokePermission instead] Revokes a credential-level permission from a user or role.

[DEPRECATED—please use revokePermission instead] Revokes a data source permission from a user or role.

[DEPRECATED—please use revokePermission instead] Revokes a KiFS directory-level permission from a user or role.

[DEPRECATED—please use revokePermission instead] Revokes a proc-level permission from a user or role.

[DEPRECATED—please use revokePermission instead] Revokes a system-level permission from a user or role.

[DEPRECATED—please use revokePermission instead] Revokes a table-level permission from a user or role.

Revokes membership in a role from a user or role.

Shows information about one or more backups accessible via the data source specified by datasourceName.

Shows information about a specified credential or all credentials.

Shows information about a specified data sink or all data sinks.

Shows information about a specified data source or all data sources.

Shows information about directories in KiFS.

Shows information about a specified user-defined function (UDF) environment or all environments.

Shows information about files in KiFS.

Shows information and characteristics of graphs that exist on the graph server.

Shows information about a proc.

Shows the statuses of running or completed proc instances.

Requests resource group properties.

Returns information about the internal sub-components (tiered objects) which use resources of the system.

Requests various statistics for storage/memory tiers and resource groups.

Retrieves information about a schema (or all schemas), as specified in schemaName.

Shows security information relating to users and/or roles.

Shows information about SQL procedures, including the full definition of each requested procedure.

Retrieves the collected column statistics for the specified table(s).

Returns server configuration and version related information to the caller.

Provides server configuration and health related status to the caller.

Returns the last 100 database requests along with the request timing and internal job ID.

Retrieves detailed information about a table, view, or schema, specified in tableName.

Retrieves the user provided metadata for the specified tables.

Show table monitors and their properties.

Gets names of the tables whose type matches the given criteria.

Retrieves information regarding the specified triggers or all existing triggers currently active.

Retrieves information for the specified data type ID or type label.

Retrieves information about rendered videos.

Requests table write-ahead log (WAL) properties.

Solves an existing graph for a type of problem (e.g., shortest path, page rank, traveling salesman, etc.) using source nodes, destination nodes, and additional, optional weights and restrictions.

Runs multiple predicate-based updates in a single call.

Runs multiple predicate-based updates in a single call.

Runs multiple predicate-based updates in a single call.

Uploads one or more files to KiFS.

Uploads one or more files to KiFS.

Inspects the requested database backup(s) for conformity at the remote file store accessible via the data source specified by datasourceName.

Scatter plot is the only plot type currently supported.

Generate an image containing isolines for travel results using an existing graph.