> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/gridgain-9/release-notes_9.0.15.md).

# GridGain 9.0.15 Release Notes

GridGain 9.0.15 adds SQL schema support, metastorage compaction, and query and transaction cancellation from Java clients.

## Overview

GridGain 9.0.15 is a release that brings a large number of new features and several major behavior changes.

## New Features

### SQL Schema Support

Prior to this release, you could only use the PUBLIC schema. You can now create other schemas and use it to create tables.

To create a schema, use the [CREATE SCHEMA](broken://spaces/BfPLkyMnD0BAfMCRhZKr/pages/fOIc7DVn1Lm6sWKENVNz#create-schema) statement:

```sql
CREATE SCHEMA myschema
```

Once the schema is created, you can create tables in it by providing a qualified table name:

```sql
CREATE TABLE IF NOT EXISTS myschema.Person (
  id int primary key,
  city_id int,
  name varchar,
  age int,
  company varchar
)
```

### Metastorage Compaction

With this release, GridGain will automatically prune metastorage information that is no longer required. As a result, the amount of space required for metastorage is expected to go down.

### Stopping SQL Queries, Transactions and Compute Jobs from Java Clients

With this release, the `CancelHandle` object can be used by Java client to stop queries, transactions and compute jobs.

## Improvements and Fixed Issues

| Issue ID  | Category                            | Description                                                                                               |
| --------- | ----------------------------------- | --------------------------------------------------------------------------------------------------------- |
| IGN-26838 | SQL                                 | Added a new SCHEMAS system view.                                                                          |
| IGN-26835 | CLI Tool                            | Fixed an issue that sometime prevented using SQL from CLI tool when authentication was enabled.           |
| IGN-26681 | SQL                                 | Added a column\_ordinal column to TABLE\_COLUMNS system view.                                             |
| IGN-25986 | Platforms and Clients               | Added support for stopping queries from java clients.                                                     |
| IGN-25611 | General                             | Metastorage is now pruned automatically.                                                                  |
| IGN-22775 | SQL                                 | Improved readability of EXPLAIN command output.                                                           |
| GG-42277  | General                             | Multiple libraries updated to fix CVEs.                                                                   |
| GG-41857  | General                             | Java 17 and 21-based GridGain docker images are now available.                                            |
| GG-41712  | Cluster Data Snapshots and Recovery | Added new ignite.pitr.threadPoolSize configuration.                                                       |
| GG-41328  | GridGain Integrations               | Kafka source: added source.offset.mode and source.offset.fail.mode to control connector restart behavior. |
| GG-41287  | Cluster SQL Engine                  | Cache-specific transactions are now available in the transactions system view.                            |

## Known Limitations

### Data Restoration After Data Rebalance

Currently, data rebalance may cause partition distribution to change and cause issues with snapshots and data recovery. In particular:

* It is currently not possible to create a snapshot on a cluster if data rebalance happened after table creation. This will be addressed in the next release.
* It is currently not possible to restore a `LOCAL` snapshot if data rebalance happened after snapshot creation. This will be addressed in one of the upcoming releases.
* It is currently not possible to perform point-in-time recovery if data rebalance happened after table creation. This will be addressed in one of the upcoming releases.

### Data Center Replication with Multiple Data Centers

Complex Data Center Replication topologies (for example, the ones involving cycles) of 3 or more data centers are not supported. This will be addressed in an upcoming releases.

### GridGain 8 Features

The following features of GridGain 8 are not available in this version, and will be added in upcoming versions:

* Rack-Awareness
* Tracing
* Service Grid

### SQL Performance in Complex Scenarios

There are known issues with the performance of SQL read-write transactions in complex read-write scenarios. These issues will be addressed in an upcoming releases.

## We Value Your Feedback

Your comments and suggestions are always welcome. You can reach us here: <http://support.gridgain.com/>.