The following are new features for Scylla Open Source 4.x
Change Data Capture (CDC) query the history of all changes made to the table. GA in Scylla 4.3. In versions prior to Scylla Open Source 4.3, CDC is an experimental feature and you need to enable it in order to use it.
The following are new features for Scylla Open Source 3.3
Clients Table real-time information on CQL clients connected to the Scylla cluster.
The following are new features for Scylla Open Source 3.2.x
IPv6 support for client-to-node, node-to-node, Manager to node, and Monitor to node communication - Scylla now supports IPv6 Global Scope Addresses for all IPs: seeds, listen_address, broadcast_address etc. This functionality is available for Scylla Manager in Scylla Manager 2.0 and in Scylla Monitor in 3.0.
Like Operator - when used on
SELECT statements informs Scylla that you are looking for a pattern match. The expression ‘column LIKE pattern’ yields true only if the entire column value matches the pattern.
Group Results - using the CQL
GROUP BY option you can condense into a single row all selected rows that share the same values for a set of columns.
Non-Frozen UDTs - User Defined Types that are not in a collection do not have to be frozen. UDTs in a collection must be frozen.
Auto-expanding Replication Factor - allows you to set a single replication factor for all Data Centers, including all existing Data Centers.
Open range deletions - deletes rows based on an open-ended request (>, <, >=, =<, etc.)
The following are new features for Scylla Open Source 3.1.x
CQL Per Partition Limit - This new per partition limit further allows you to set the number of partitions returned as a result. You can mix both row limits and per partition limits in the same CQL statement.
Local Secondary Indexes - More efficient Secondary Index searches when the base table and index share the same partition key.
BYPASS CACHE - This CQL command introduced in Scylla Enterprise 2019.1.1, now available in open source, informs the database that the data being read is unlikely to be read again in the near future, and also was unlikely to have been read in the near past; therefore no attempt should be made to read it from the cache or to populate the cache with the data.
Large Cell / Collection Detector - Makes finding large partitions easier.
Nodetool toppartitions - Samples cluster writes and reads and reports the most active partitions in a specified table and time frame.
ALLOW FILTERING CQL Command that allows for server side data filtering that is not based on the primary key. Introduced in 3.0, this feature was further enhanced in version 3.1.
The following are new features for Scylla Open Source 3.0.x
Scylla Materialized Views - An alternate view table for finding a partition by the value of another column. Experimental in prior versions, this feature was made production ready in Scylla Open Source 3.0.
Global Secondary Indexes - A mechanism for allowing efficient searches on non-partition keys using Materialized Views. Experimental in prior versions, this feature was made production ready in Scylla Open Source 3.0.
Hinted Handoff - ensures availability and consistency
SSTable 3.0 - new SSTable format
ALLOW FILTERING CQL Command that allows for server side data filtering that is not based on the primary key.
More information in the Release Notes.