Functions

Feature Name	Description
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 Offline	Pauses consumption of messages from other HA clusters.
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: Repair Table	Manually repair a corrupted table.
Administration: Send Alert	Send an alert to the monitoring system.
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 Backup	Alter a database backup.
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.
Alter WAL	Alters table write-ahead log (WAL) settings.
Append Records	Append records from a source table to a target table based on the field map.
Check Table	Shows information relating corrupt table entries.
Clear Statistics	Clears statistics for column(s) in a table.
Clear Table	Delete a table.
Clear Table Monitor	Deactivate a table monitor.
Clear Tables	Delete tables.
Clear Trigger	Delete a trigger.
Collect Statistics	Collect statistics on a column.
Create Asynchronous Job	Create a new job to be executed asynchronously.
Create Backup	Create a database backup.
Create Catalog	Create a catalog.
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 Backup	Deletes a database backup.
Drop Catalog	Drop an existing catalog.
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 Query Metrics	Export query metrics to a given destination.
Export Records from Table	Export records from table.
Export Records to External Database Table	Exports records from source table to the specified target table in an external database.
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 Graph Entities	Retrieve graph nodes or edges.
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 External Database	Insert records from external database from a given query into the specified target 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 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.
Modify Graph	Update an existing graph network.
Query Graph	Queries an existing graph.
Repartition Graph	Rebalance existing partitioned graph network.
Restore Backup	Restores a backup.
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 Backup	Show information about backups.
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	Show information 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 groups.
Show Resource Objects	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.
Show WAL	Shows information relating to table write-ahead log (WAL) entries.
Solve Graph	Solves an existing graph.
Unpivot Table	Rotate column values into rows values.
Update Records	Perform predicate-based updates to table data.
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.
Verify Backup	Shows detailed information about corrupt backups.
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.