Functions

Feature Name	Description
Admin Repair Table	Manually repair a corrupted table
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: 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
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 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 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
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 the 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.
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 a backup.
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.
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
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