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 |