6.0 Release Notes

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

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
  • 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

Security

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

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 6.0.1

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
  • Tensorflow added to the User-Defined Function runtime environment

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