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: 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: Switchover Process Manually switchover 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 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 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 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 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.
Execute Proc Execute a proc
Execute SQL Execute a SQL statement (query, DML, or DDL)
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 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 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 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 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
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