6.0 Release Notes¶

Contents

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

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
Full NULL support
Added Decimal, Date, & Time column types
Support for renaming tables and adding/modifying/deleting columns in place
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

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

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

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