6.5 Beta Release Notes

The MemSQL 6.5 Beta releases include new features and functionality for you experiment with in your test environments. Functionality may change between now and the next major release of MemSQL.

See the descriptions and changelog below for more information on these new features.

Data Loading

HDFS Pipeline Support

A new HDFS pipeline allows you to perform ETL operations on files from Hadoop, Pig, or Spark jobs. See HDFS Pipelines Overview for more details.

Kerberos and SSL support for Kafka Pipelines

You can now configure Kafka pipelines to connect to your Kafka brokers through SSL and optionally authenticate with Kerberos. See Enabling SSL and Kerberos on Kafka Pipelines for more details.

Pipeline Support with Stored Procedures

In previous versions of MemSQL, you could only insert into one table for each pipeline that you created. Now in MemSQL 6.5 and later, you can insert into multiple tables from one pipeline by specifying a stored procedure in a CREATE PIPELINE command.

Having pipeline support with stored procedures also means supporting new scenarios such as data transformation in SQL. See the INTO PROCEDURE section of CREATE PIPELINE for more details.

Performance improvements for loading into S3 Pipelines

S3 pipelines now have the ability to process new files in a bucket at a much faster rate without incurring the penalty of listing all of the files in the bucket before performing the ETL operations of the pipeline. Previously, this could be a slow operation if you had a bucket with a large file count.

The only requirement to enable this new functionality is to prefix filenames in your bucket with an increasing alpha-numeric value, such as a timestamp or some other marker (e.g. YYYY-MM-DD-filename.extension). You do not need to add any configuration elements to your CREATE PIPELINE statement.

Backup and Restore from S3

You can now backup and restore your databases to a S3 bucket. See BACKUP and RESTORE for syntax and additional details.

General Improvements

Query Language Additions

FULL OUTER JOIN now supported

See SELECT for more details on usage.

PIVOT

You can now transform non-aggregated event data into a pivot table output format using the PIVOT clause in a SELECT statement. See PIVOT for more details.

Full text search allows searching for words or phrases in columnstore table columns with a large body of text. See Full Text Search for more details.

Query Execution

Query Optimization

Extensibility

Cluster Manageability

SSL for cross-cluster communication decoupled from SSL for intra-cluster communication

You can now configure your cluster to use SSL for communication between clusters during replication only, and have it off for local communication between nodes. This can be useful if the performance cost of securing intra-cluster communication is too high for your workload. See Server Configuration for Secure Client and Intra-Cluster Connections for more details.

Resource Governance

Memory limits can now be set to prevent unintended queries from consuming all available query execution memory in the cluster. See Setting Resource Limits for more details.

Workload Management

MemSQL now estimates the amount of memory required to execute queries and only runs those queries if sufficient memory is available. See Workload Management for more information.

Synchronize User Permissions Across the Cluster

You can now set and update cluster-wide user permissions on the master aggregator and have those changes synchronized to all nodes in your cluster by setting sync_permissions to ON in your master aggregator.

General Improvements

Maintenance Release Changelog

2018-07-03 Version 6.5.7-RC1

2018-06-15 Version 6.5.6-beta3

2018-06-06 Version 6.5.5-beta3

2018-05-17 Version 6.5.4-beta2

2018-03-05 Version 6.5.1-beta1

Was this article useful?