Version:

Release Notes


Version 6.1.0

Features

  • The Kinetica deployment process has been simplified. After installing Kinetica, no command line or config file interactions are necessary. The Kinetica Administration Application (GAdmin) interface handles all deployment administration, even across multiple nodes
  • The new Host Manager service is an independent supervisor process that manages several processes that are part of Kinetica, restarting them automatically should they fail unexpectedly. Host Manager also helps investigate problems and monitor cluster-wide performance. With the advent of Host Manager, passwordless SSH is no longer required
  • A new Jobs (Job Manager) feature monitors all incoming jobs for Kinetica and maintains request ordering across the nodes in your Kinetica cluster. Job Manager can assist in cancelling extremely long or stalled jobs

Security

  • Reveal is now integrated with the Kinetica authorization system
  • Kinetica now supports mapping database roles to LDAP/Active Directory groups
  • Database auditing capability per user and per endpoint has been significantly improved

Core

Geospatial

  • By moving to a new OpenGL Framework architecture, geospatial visualizations--most notably polygon and line geometries with high vertex counts, scatter plots, and complex graphs or charts--have been greatly improved
  • 2D Chart rendering has also been accelerated
  • Added the highest priority filters and geospatial functions as defined by both ST_Geometry and ArcGIS to enhance geospatial processing
  • Geospatial (WKT) data is now a "first-class citizen"; the WKT column data sub type is available as either a string or byte primitive type
  • Spatial joins via Expressions and APIs where expressions are supported

SQL

  • All new geospatial functions have been exposed for SQL usage
  • Operations: INSERT, DELETE, CREATE TABLE, CREATE TABLE AS
  • Table alteration from SQL is now supported
  • Data type: DATETIME

Projections

  • Projections now support dynamically-selected shard attributes
  • Projections can now be persisted

User-Defined Functions (UDFs)

  • Performance enhancements to accelerate output table creation
  • Improved GPU multi-tenancy by including GPU usage metrics data structure
  • Deepchem package added to the User-Defined Function runtime environment

Cloud Deployment

  • Marketplace instances with proper licensing and monitoring hooks are now available for AWS and Azure
  • An auto-launcher for AWS and Azure has been developed to allow users to "bring your own license" and set cluster size parameters for easy button deployment

Version 6.0.1

Features

  • Tensorflow added to the User-Defined Function runtime environment

API

  • New C# language bindings for the Kinetica API
  • Improved default Java API ingest performance
  • Enhanced /alter/table support
  • New ttl (Time to Live) option for /create/union, /create/projection, /create/jointable, /aggregate/groupby, /aggregate/unique, /filter
  • Various helper classes and constants added to the APIs
  • New failover URL support for the Java API
  • Secure communications (HTTPS) enabled for the C++ API

Core

  • Improving performance and types of JOIN operations supported
  • Various bug fixes and performance & stability improvements
  • Heatmaps are available in non-GPU mode

SQL

  • Operations: WITH (Common Table Expressions), INTERSECT, EXCEPT, UPDATE, DELETE, CREATE REPLICATED TABLE, CREATE [OR REPLACE] TABLE ... AS, ALTER TABLE, and DROP TABLE IF EXISTS
  • Functions: POSITION, CAST, DECODE, ZEROIFNULL, and DATEDIFF
  • Types: Fixed-limit strings to optimize memory usage & performance
  • New 32-bit Windows client for ODBC
  • Various enhancements for general SQL support



Version 6.0

Features

  • Reveal data exploration tool and analytics GUI
  • User-Defined Function Framework
    • User-defined binaries can receive table data, perform computations, and persist results in a distributed manner
    • Orchestration API provided in C++ and Java bindings; integrates with high-speed IPC layer of every data container
  • Visual Installer--allows for easy click-button installation across hundreds of nodes

Types

  • Full NULL support
  • Decimal
  • Date
  • Time

Data Operations

  • Union, intersect & minus set operations
  • Multi-column order-by support
  • Added projections--filters that allow column expressions in the result set column list
  • Moving average capability

Security

  • Integration with LDAP & Kerberos
  • Table-level data access control per user

Core

  • Increased node capacity & utilization, with active memory management; operations are host memory aware and write to disk, as needed
  • GPU-only column designation for accelerated query performance

API

  • Support for renaming tables and adding/modifying/deleting columns in place

SQL

  • Operations: CROSS JOIN, FULL OUTER JOIN, UNION DISTINCT, UPDATE, DELETE, CREATE TABLE, DROP TABLE
  • Functions: LIKE
  • Types: DECIMAL(P,S), TYPE_DATE, & TYPE_TIME



Version 5.2

Types

  • 32, 64, 128, & 256 byte character strings
  • Initial NULL support

Functions

  • Character-based: lower, upper, min, max, ltrim, rtrim & trim
  • Geographic: wkt_dist & wkt_is_within_dist
  • Null: is_null, nvl, nvl2 & nullif

Data Operations

  • Added support for inner, left & right join set operations
  • Added filter planner for displaying join path
  • Added set concatenation operation
  • Aggregation result sets can be made into views

Security

  • Added role-based security and supporting endpoints
  • Removed passphrase-based authorization checks; no longer needed in new security model

GAdmin

  • Added to HA & security infrastructures
  • Sortable data grid columns
  • Added to table view: shard & foreign keys, replicated & protected statuses, TTL

API

  • Collapsed /alter/table/* and /show/table/* endpoints

Connectors

  • Increased stability & performance across connectors

SQL

  • Operations: JOIN, LEFT/RIGHT JOIN, EXISTS, SELECT DISTINCT, TOP, UNION ALL & IN
  • Functions: CASE, CONVERT, IFNULL, NOT, TIMESTAMPADD, TRUNCATE