| Administration: Add Host |
Adds a host to the cluster. |
| Administration: Add Ranks |
Add new ranks to the Kinetica cluster |
| Administration: Alter Host |
Alter properties on a host currently in the cluster |
| Administration: Alter Job |
Alter a job |
| Administration: Begin Backup |
Prepares the system for a backup operation |
| Administration: End Backup |
End system backup mode |
| Administration: HA refresh |
Restarts HA to handle breaking conf changes |
| Administration: Rebalance |
Rebalance data and/or shards across all nodes in a cluster |
| Administration: Remove Host |
Removes a host from the cluster. |
| Administration: Remove Ranks |
Remove rank(s) from the Kinetica cluster |
| Administration: Show Alerts |
Show a list of generated alerts. |
| Administration: Show Cluster Operations |
Show cluster operations (add/remove ranks or rebalance) status |
| Administration: Show Jobs |
Show the current jobs in GPUdb |
| Administration: Show Shards |
Show the mapping of the shards to the ranks |
| Administration: Switch Over Process |
Manually switch over one or more processes to another host |
| Administration: System Offline |
Take the system offline |
| Administration: System Shutdown |
Stop the database server application |
| Administration: Verify Database |
Verify database is in a consistent state |
| Aggregate Convex Hull |
Calculate and return the convex hull for a dataset |
| Aggregate Group By |
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 K-means |
Run the k-means algorithm on a dataset |
| Aggregate Min/Max |
Calculate the min and max values of a column in a dataset |
| Aggregate Min/Max 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 by Range |
Divide a dataset into bins and calculate statistics of the values |
| Aggregate Unique |
Find unique values in a column |
| Alter Credential |
Alter an existing credential |
| Alter Data Sink |
Alter an existing data sink |
| Alter Data Source |
Alter an existing data source |
| Alter Directory |
Alter an existing directory in KiFS |
| Alter Resource Group |
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 Table Monitor |
Alter an existing table monitor |
| Alter Tier |
Alter an existing tier |
| Alter UDF environment |
Alter an existing UDF environment |
| 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 Table Monitor |
Deactivate a table monitor |
| Clear Trigger |
Delete a trigger |
| Collect Statistics |
Collect statistics on a column. |
| Create Asynchronous Job |
Create a new job to be executed asynchronously |
| Create Credential |
Create a new credential. |
| Create Data Sink |
Create a data sink |
| Create Data Source |
Create a data source |
| Create Directory |
Create a directory in KiFS |
| Create External Table |
Create a new external table |
| Create External User |
Create a new external user |
| Create Graph |
Create a new graph network. |
| Create Internal User |
Create a new internal user |
| Create Join Table |
Create a table that is the result of a SQL JOIN |
| Create Materialized View |
Begin the creation a materialized view |
| Create Proc |
Create a proc |
| Create Projection |
Create a projection of an existing table |
| Create Resource Group |
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 Monitor |
Create a table monitor that will watch for and queue any records added |
| Create Trigger by Area |
Create a table trigger for new records falling within a 2-D boundary |
| Create Trigger by Range |
Create a table trigger for new records falling within a 1-D range |
| Create Type |
Create a table record type |
| Create UDF Environment |
Create a UDF environment |
| Create Union |
Create a table that is the merge of one or more tables |
| 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 Resource Group |
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 Data Sink |
Drop an existing data sink |
| Drop Data Source |
Drop an existing data source |
| Drop Schema |
Drop an existing SQL-style schema. |
| Drop UDF Environment |
Drop an existing UDF environment |
| Execute Proc |
Execute a proc |
| Execute SQL |
Execute a SQL statement (query, DML, or DDL) |
| Export records from table |
Export records from table |
| Filter |
Filter a dataset for records matching an expression |
| Filter Geometry by Area |
Filter a dataset for geospatial geometry objects intersecting a 2-D polygon |
| Filter Geometry by Box |
Filter a dataset for geospatial geometry objects intersecting a rectangle's boundary |
| Filter Geometry by Radius |
Filter a dataset for geospatial geometry objects intersecting a circle's boundary |
| Filter by Area |
Filter a dataset for records falling within a 2-D polygon's boundary |
| Filter by Box |
Filter a dataset for records within a rectangle's boundary |
| Filter by Geometry |
Filter a dataset for records in relation to a given WKT geometry's boundary |
| Filter by List |
Filter a dataset for records with specific column values |
| Filter by Radius |
Filter a dataset for records within a circle's boundary |
| Filter by Range |
Filter a dataset for records within a 1-D range |
| Filter by Series |
Filter a dataset for records within a track's space/time boundary |
| Filter by String |
Filter a dataset for records with matching column text values |
| Filter by Table |
Filter a dataset for records with column values matching another table's column values |
| Filter by Value |
Filter a dataset for records matching a specific value |
| Get Asynchronous Job Result |
Get the status and result of asynchronously running job |
| Get JSON Records |
Get records in JSON format |
| Get Records |
Retrieve records from a table with optional filtering and sorting |
| Get Records by Column |
Retrieve the values of the given columns within a specified range. |
| Get Records by Series |
Retrieve the complete series/track records from partial track information |
| Get Records from Collection |
[DEPRECATED] Retrieve records from a collection, optionally returning the record IDs |
| Grant Credential Permission |
Grant a credential-level permission to a user or role |
| Grant Data Source Permission |
Grant a data source permission to a user or role |
| Grant Directory Permission |
Grant a KiFS directory-level permission to a user or role |
| Grant Permission |
Grant user or role the specified permission on the specified object |
| Grant Proc Permission |
Grant a proc-level permission to a user or role |
| Grant Role |
Grant membership in a role to a user or role |
| Grant System Permission |
Grant a system-level permission to a user or role |
| Grant Table Permission |
Grant a table-level permission 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 JSON Records |
Insert records in JSON format |
| Insert Records |
Add records to specified table |
| Insert Records Random |
Generate random records and insert into specified table |
| Insert Records from File(s) |
Insert records from one or more files into the specified target table |
| Insert Records from Payload |
Insert records from a text-based or binary payload into the specified target table |
| Insert Records from external database |
Insert records from external database from a given query into the specified target table |
| Insert Records to table in external database |
Exports records from source table to specified target table in an external database |
| 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 Credential Permission |
Revoke a credential-level permission from a user or role |
| Revoke Data Source Permission |
Revoke a data source permission from a user or role |
| Revoke Directory Permission |
Revoke a KiFS directory-level permission from a user or role |
| Revoke Permission |
Revoke from user or role the specified permission on the specified object |
| Revoke Proc Permission |
Revoke a proc-level permission from a user or role |
| Revoke Role |
Revoke membership in a role from a user or role |
| Revoke System Permission |
Revoke a system-level permission from a user or role |
| Revoke Table Permission |
Revoke a table-level permission from a user or role |
| Show Credential |
Show information about a credential. |
| Show Data Sink |
Show information about a data sinks. |
| Show Data Source |
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 Graphs |
Info about graphs. |
| Show Proc |
Show information about a proc. |
| Show Proc Status |
Show the statuses of running or completed proc instances. |
| Show Resource Group |
Shows information relating to resource objects |
| Show Resource Statistics |
Show statistics for tier and resource groups |
| Show SQL Procedure |
Show information about a SQL Procedure. |
| 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 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 Table Monitors |
Show information about table monitors |
| Show Table Statistics |
Show collected statistics for the specified table |
| Show Tables by Type |
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. |
| Unpivot Table |
Rotate column values into rows values. |
| Update Records |
Perform predicate-based updates to table data |
| Update Records by Series |
Update a view to include all series/track information for contained series/track |
| Upload Files |
Upload one or more files to KiFS |
| Upload Files From URL |
Upload one or more files to KiFS from a URL list |
| Vector Tile Service |
VTS capability |
| Visualize Image Chart |
Draw a chart from specified tables and return it as an image. |
| Visualize Isochrone |
Draw isolines for travel results. |
| Web Map Service |
WMS capability |
