7.1 Release Notes

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

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

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