| /admin/add/host |
Adds a host to the cluster. |
| /admin/add/ranks |
Add new ranks to the Kinetica cluster |
| /admin/alter/host |
Alter properties on a host currently in the cluster |
| /admin/alter/jobs |
Alter a job |
| /admin/backup/begin |
Prepares the system for a backup operation |
| /admin/backup/end |
End system backup mode |
| /admin/ha/refresh |
Restarts HA to handle breaking conf changes |
| /admin/offline |
Take the system offline |
| /admin/rebalance |
Rebalance data and/or shards across all nodes in a cluster |
| /admin/remove/host |
Removes a host from the cluster. |
| /admin/remove/ranks |
Remove rank(s) from the Kinetica cluster |
| /admin/show/alerts |
Show a list of generated alerts. |
| /admin/show/cluster/operations |
Show cluster operations (add/remove ranks or rebalance) status |
| /admin/show/jobs |
Show the current jobs in GPUdb |
| /admin/show/shards |
Show the mapping of the shards to the ranks |
| /admin/shutdown |
Stop the database server application |
| /admin/switchover |
Manually switch over one or more processes to another host |
| /admin/verifydb |
Verify database is in a consistent state |
| /aggregate/convexhull |
Calculate and return the convex hull for a dataset |
| /aggregate/groupby |
Calculate unique combinations of values for the given columns in a given dataset |
| /aggregate/histogram |
Perform a histogram calculation given a table, column, and interval function |
| /aggregate/kmeans |
Run the k-means algorithm on a dataset |
| /aggregate/minmax |
Calculate the min and max values of a column in a dataset |
| /aggregate/minmax/geometry |
Calculate the min and max x- and y- coordinates of a geospatial geometry column in a dataset |
| /aggregate/statistics |
Calculate statistics of a dataset |
| /aggregate/statistics/byrange |
Divide a dataset into bins and calculate statistics of the values |
| /aggregate/unique |
Find unique values in a column |
| /aggregate/unpivot |
Rotate column values into rows values. |
| /alter/credential |
Alter an existing credential |
| /alter/datasink |
Alter an existing data sink |
| /alter/datasource |
Alter an existing data source |
| /alter/directory |
Alter an existing directory in KiFS |
| /alter/environment |
Alter an existing UDF environment |
| /alter/resourcegroup |
Alter an existing resource group |
| /alter/role |
Alter a Role |
| /alter/schema |
Alter a SQL-style schema. |
| /alter/system/properties |
Alter system configuration |
| /alter/table |
Modify various properties of a table or view |
| /alter/table/columns |
Modify various properties of multiple columns in a table (multiple alter/table requests for columns) |
| /alter/table/metadata |
Alter metadata for tables |
| /alter/tablemonitor |
Alter an existing table monitor |
| /alter/tier |
Alter an existing tier |
| /alter/user |
Alter a user |
| /alter/video |
Alter a video. |
| /append/records |
Append records from a source table to a target table based on the field map |
| /clear/statistics |
Clears statistics for column(s) in a table. |
| /clear/table |
Delete a table |
| /clear/tablemonitor |
Deactivate a table monitor |
| /clear/trigger |
Delete a trigger |
| /collect/statistics |
Collect statistics on a column. |
| /create/credential |
Create a new credential. |
| /create/datasink |
Create a data sink |
| /create/datasource |
Create a data source |
| /create/directory |
Create a directory in KiFS |
| /create/environment |
Create a UDF environment |
| /create/graph |
Create a new graph network. |
| /create/job |
Create a new job to be executed asynchronously |
| /create/jointable |
Create a table that is the result of a SQL JOIN |
| /create/materializedview |
Begin the creation a materialized view |
| /create/proc |
Create a proc |
| /create/projection |
Create a projection of an existing table |
| /create/resourcegroup |
Create a new resource group |
| /create/role |
Create a new role |
| /create/schema |
Create a SQL-style schema. |
| /create/table |
Create a new table |
| /create/table/external |
Create a new external table |
| /create/tablemonitor |
Create a table monitor that will watch for and queue any records added |
| /create/trigger/byarea |
Create a table trigger for new records falling within a 2-D boundary |
| /create/trigger/byrange |
Create a table trigger for new records falling within a 1-D range |
| /create/type |
Create a table record type |
| /create/union |
Create a table that is the merge of one or more tables |
| /create/user/external |
Create a new external user |
| /create/user/internal |
Create a new internal user |
| /create/video |
Create a video. |
| /delete/directory |
Delete a directory from KiFS |
| /delete/files |
Delete one or more files from KiFS |
| /delete/graph |
Deletes a graph. |
| /delete/proc |
Delete a proc |
| /delete/records |
Delete matching records from a dataset |
| /delete/resourcegroup |
Deletes a resource group |
| /delete/role |
Delete an existing role |
| /delete/user |
Delete an existing user |
| /download/files |
Download one or more files from KiFS |
| /drop/credential |
Drop an existing credential |
| /drop/datasink |
Drop an existing data sink |
| /drop/datasource |
Drop an existing data source |
| /drop/environment |
Drop an existing UDF environment |
| /drop/schema |
Drop an existing SQL-style schema. |
| /execute/proc |
Execute a proc |
| /execute/sql |
Execute a SQL statement (query, DML, or DDL) |
| /export/records/tofiles |
Export records from table |
| /export/records/totable |
Exports records from source table to specified target table in an external database |
| /filter |
Filter a dataset for records matching an expression |
| /filter/byarea |
Filter a dataset for records falling within a 2-D polygon's boundary |
| /filter/byarea/geometry |
Filter a dataset for geospatial geometry objects intersecting a 2-D polygon |
| /filter/bybox |
Filter a dataset for records within a rectangle's boundary |
| /filter/bybox/geometry |
Filter a dataset for geospatial geometry objects intersecting a rectangle's boundary |
| /filter/bygeometry |
Filter a dataset for records in relation to a given WKT geometry's boundary |
| /filter/bylist |
Filter a dataset for records with specific column values |
| /filter/byradius |
Filter a dataset for records within a circle's boundary |
| /filter/byradius/geometry |
Filter a dataset for geospatial geometry objects intersecting a circle's boundary |
| /filter/byrange |
Filter a dataset for records within a 1-D range |
| /filter/byseries |
Filter a dataset for records within a track's space/time boundary |
| /filter/bystring |
Filter a dataset for records with matching column text values |
| /filter/bytable |
Filter a dataset for records with column values matching another table's column values |
| /filter/byvalue |
Filter a dataset for records matching a specific value |
| /get/job |
Get the status and result of asynchronously running job |
| /get/records |
Retrieve records from a table with optional filtering and sorting |
| /get/records/bycolumn |
Retrieve the values of the given columns within a specified range. |
| /get/records/byseries |
Retrieve the complete series/track records from partial track information |
| /get/records/fromcollection |
[DEPRECATED] Retrieve records from a collection, optionally returning the record IDs |
| /get/records/json |
Get records in JSON format |
| /grant/permission |
Grant user or role the specified permission on the specified object |
| /grant/permission/credential |
Grant a credential-level permission to a user or role |
| /grant/permission/datasource |
Grant a data source permission to a user or role |
| /grant/permission/directory |
Grant a KiFS directory-level permission to a user or role |
| /grant/permission/proc |
Grant a proc-level permission to a user or role |
| /grant/permission/system |
Grant a system-level permission to a user or role |
| /grant/permission/table |
Grant a table-level permission to a user or role |
| /grant/role |
Grant membership in a role to a user or role |
| /has/permission |
Check if user has specified permission on the specified object |
| /has/proc |
Check for existence of specified proc |
| /has/role |
Check if user has specified role |
| /has/schema |
Check for the existence of specified schema |
| /has/table |
Check for the existence of specified table |
| /has/type |
Check for the existence of specified type |
| /insert/records |
Add records to specified table |
| /insert/records/fromfiles |
Insert records from one or more files into the specified target table |
| /insert/records/frompayload |
Insert records from a text-based or binary payload into the specified target table |
| /insert/records/fromquery |
Insert records from external database from a given query into the specified target table |
| /insert/records/json |
Insert records in JSON format |
| /insert/records/random |
Generate random records and insert into specified table |
| /insert/symbol |
Add rendering symbol or icon to the database |
| /kill/proc |
Kill a running proc instance |
| /lock/table |
Set read or write locks on a table |
| /match/graph |
Match sample points to a graph. |
| /merge/records |
Merge records from multiple source tables to a new result table |
| /modify/graph |
Update an existing graph network. |
| /query/graph |
Queries an existing graph. |
| /repartition/graph |
Rebalance existing partitioned graph network. |
| /revoke/permission |
Revoke from user or role the specified permission on the specified object |
| /revoke/permission/credential |
Revoke a credential-level permission from a user or role |
| /revoke/permission/datasource |
Revoke a data source permission from a user or role |
| /revoke/permission/directory |
Revoke a KiFS directory-level permission from a user or role |
| /revoke/permission/proc |
Revoke a proc-level permission from a user or role |
| /revoke/permission/system |
Revoke a system-level permission from a user or role |
| /revoke/permission/table |
Revoke a table-level permission from a user or role |
| /revoke/role |
Revoke membership in a role from a user or role |
| /show/credential |
Show information about a credential. |
| /show/datasink |
Show information about a data sinks. |
| /show/datasource |
Show information about a data source. |
| /show/directories |
Show information about directories in KiFS |
| /show/environment |
Show information about a environment. |
| /show/files |
Show information about files in KiFS |
| /show/graph |
Info about graphs. |
| /show/proc |
Show information about a proc. |
| /show/proc/status |
Show the statuses of running or completed proc instances. |
| /show/resource/objects |
Shows information relating to resource objects |
| /show/resource/statistics |
Show statistics for tier and resource groups |
| /show/resourcegroups |
Shows information relating to resource groups |
| /show/schema |
Show information about a single SQL-style schema or all schemas. |
| /show/security |
Show security information relating to users and/or roles. |
| /show/sql/proc |
Show information about a SQL Procedure. |
| /show/statistics |
Show collected statistics for the specified table |
| /show/system/properties |
Show the server configuration and version information |
| /show/system/status |
Show server configuration and health status |
| /show/system/timing |
Show the last 100 requests, the request timing, and internal job id |
| /show/table |
Show information about tables, views, or schemas. |
| /show/table/metadata |
Show metadata for the specified table |
| /show/tablemonitors |
Show information about table monitors |
| /show/tables/bytype |
Show table names of specified type |
| /show/triggers |
Show information for specified or all triggers |
| /show/types |
Show information for specified types |
| /show/video |
Retrieve information about rendered videos. |
| /solve/graph |
Solves an existing graph. |
| /update/records |
Perform predicate-based updates to table data |
| /update/records/byseries |
Update a view to include all series/track information for contained series/track |
| /upload/files |
Upload one or more files to KiFS |
| /upload/files/fromurl |
Upload one or more files to KiFS from a URL list |
| /visualize/image/chart |
Draw a chart from specified tables and return it as an image. |
| /visualize/isochrone |
Draw isolines for travel results. |
| /vts |
VTS capability |
| /wms |
WMS capability |
