Note
This documentation is for a prior release of Kinetica. For the latest documentation, click here.
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