Publish Date: 08/19/2020
Features
- Cluster Resiliency allows failed processes within a cluster to be shifted to other active or passive hosts within the cluster
- Schemas (formerly collections) are now namespaced, allowing two or more schemas to contain a table with the same name; the native API will now accept <schema_name>.<table_name> references to tables & views
- Externally-managed data sources can be the source of both Tables and data load commands (LOAD INTO, /insert/records/fromfiles)
- Improved system & cluster monitoring capability
Core
- Ring Resiliency (High Availability) is now integrated into the core of the product; a separate package & application suite is no longer needed
- As part of the namespaced schemas change, all top-level tables & views will be relocated to the home schema.
APIs/Tools/Connectors
- All APIs, KIO, and the Spark connector have been updated to support schemas.
- APIs:
- The Java API has been updated to support cluster resiliency and the new ring resiliency changes
- The Java API now supports logging via Apache Log4j
- The Java API setHostManagerPort option will no longer work after the database object has been initialized
- KIO:
- Due to the advent of schemas, the --d-collection-name Kinetica format option has been deprecated
KAgent
- Added cluster resiliency support
- Added support for switching responsibility for one host's processes to another host, on demand
- Added support for configuring metric-based and event-based alerts
- Added support for configuring delivery channels (e.g, email) for alerts
- Added/improved monitoring of:
- Rings
- Clusters
- Nodes
- Resource groups and storage tiers
- Ring resiliency
- SQL query usage
- System events and errors
UI
KAgent
- KAgent has undergone a visual refresh as well as received some usability improvements.
- The KAgent user interface has added support for all new features listed in the 7.1 Release Notes section above.
GAdmin
- GAdmin has undergone a visual refresh as well as received some usability improvements.
- Viewing a list of tables/views will no longer prevent them from expiring by TTL
- Transitioned support for collections to schemas.
Reveal
- Kinetica Reveal has undergone a visual refresh as well as received some usability improvements.
- Transitioned support for collections to schemas
Version 7.1.2
Build Date: 11/12/20
SQL/OLAP
- Added support for SQL procedures to be executed as another user using the EXECUTE AS syntax
- Added support for short-circuiting errors using the conditional function IF and operators AND & OR
- Added four new functions:
- LOG1P(expr) -- Returns the natural logarithm of one plus expr (a double). Effectively evaluates as log(1+expr)
- LOG2(expr) -- Returns the binary (base-2) logarithm of the given expression expr (a double)
- LOG1PF(expr) -- Returns the natural logarithm of one plus expr (a float). Effectively evaluates as log(1+expr)
- LOG2F(expr) -- Returns the binary (base-2) logarithm of the given expression expr (a float)
- Removed support for using temporary tables within procedures
- Added support for new SQL statement EXECUTE ENDPOINT that allows users to execute any REST API endpoint
- Improved performance of handling GROUP BY operations resulting in a sharded table
- Improved performance of JOIN operations involving inequalities between columns in different tables
- Improved performance of /append/records operations, i.e. SQL INSERT with SELECT
Geospatial/Network Graph/Visualization
- Added support for symbology for tracks
- Corrected issues with invalid VTS render types
- Added support for solving replicated graphs using the shortest path solver
- Improved performance of track marker rendering
- Added support for tracks in the solution output for the
match_supply_demand and markov_chain /match/graph
solvers:
- For markov_chain solutions, the output details table's TRIPID column, a long, has been changed to TRACKID, a char64 sharded column. This new column can be consumed in appropriate /wms track-style calls
- For match_supply_demand solutions, a new output_tracks option is available that will update the output table to comply with TRACKID and TIMESTAMP formatting, where the TIMESTAMP is correct with respect to real-time truck travel (if the weight field of the graph was time-based). This option is useful if real-time dynamic routing simulation is desired
APIs/Tools/Connectors
- Python API
- Added support for custom headers, which enables SQL-like user impersonation at the native API level
- Improved and simplified the table monitor API
- Added support for sharding on UUID type columns in multi-head egress/ingest
- JavaScript API
- Added support for custom headers, which enables SQL-like user impersonation at the native API level
- Node.js API
- Added support for custom headers, which enables SQL-like user impersonation at the native API level
UI
- Reveal
- Added support for sorting histogram columns by field name
Version 7.1.1
Build Date: 10/22/20
SQL/OLAP
- Added support for partitioning by series
- Added support for row- and column-level security to materialized views
- Added a new ON QUERY refresh mode for materialized views.
- Added support for UPDATE statements that contain JOINs with other tables, including updating values from expressions involving other tables
- Improved efficiency of JOIN operations that use inequality within the JOIN expression
- Added support for a new uuid (GUID) type as well as related functions
Infrastructure
- The cold storage tier for resource management now supports Microsoft Azure blob and data lake storage
Geospatial/Network Graph/Visualization
- Improvements to track and shape rendering:
- Improved memory management
- Corrected WMS rendering that straddled hemisphere lines
- Improved the /filter/byradius endpoint to be spherical aware
APIs/Tools/Connectors
- Java API
- Added support for overriding system IP addresses with user-defined IP addresses provided to the API
- JavaScript API
- Added support for custom headers, which enables SQL-like user impersonation at the native API level
- NodeJS API
- Added support for custom headers, which enables SQL-like user impersonation at the native API level
- Python API
- Improved and simplified the table monitor API
- Added support for using the new uuid type with multi-head input and output
- Added support for the trace log level
- Added support for custom headers, which enables SQL-like user impersonation at the native API level
- Kafka Connector
- Added a new option, kinetica.enable_multihead, to enable multi-head data ingest for the sink connector
- RKinetica
- Added support for schema namespacing
UI
- Reveal
- Improved general usability
- GAdmin
- Added support for a new uuid (GUID) type
- Improved general usability
- KAgent
- Added support for mapping external authentication roles during security configuration
- Added a new LDAPS option to the security configuration