> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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