Version:

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: 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 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
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 Data Source Create a data source
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
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
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 Data Source Permission Grant a data source permission to a user or role
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 Proc Check for existence of specified proc
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 Random Generate random records and insert into specified table
Insert Records Request Add records to 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.
Revoke Data Source Permission Revoke a data source permission from a user or role
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 Data Source Show information about a data source.
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 groups
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 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
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
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