Release Notes

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