Maintenance Notification:
On next Monday August 5th 2019 starting at 7am CEST we will conduct some maintenance. You might encounter some issues using the Exasol User Portal and Issue Tracker! We will restore the Exasol User Portal and Issue Tracker before 9am CEST on Monday August 5th 2019.

Page tree

What is new in Version 6.1.0?

Release 6.1.0 focuses on evolution instead of revolution. We put a strong emphasis on "Enterprise Readiness" and, as always, on performance and scalability.

A short overview of what you can expect from Version 6.1.0:

Performance & Scalability

  • Table partitioning ("partition by")
    Increases the overall performance, scalability and resource efficiency by managing data objects in smaller distinct independent parts.
  • Index Structures for Geospatial functions
    Highly efficient index structures for geospatial functions for fast query evaluation on geospatial data.
  • Remote Backup & Restore performance optimizations
    Accelerates backup and restore operations. Internal benchmarks revealed a speedup of around factor 3 for backup creation and around factor 2 for restore operations.
  • Improved and accelerated string function processing
    Acceleration of string functions and operators (e.g. 'like')

Enterprise Readiness

  • SSO/Kerberos support with delegation
    Increase security and improve user experience by integrating Exasol into Kerberos-based enterprise authentication infrastructures
  • Impersonation
    Increase security and improve user experience when a Kerberos integration is not feasible
  • Flexible Priority Groups
    Flexible priority management provides means to manage a potentially large number of  user groups in terms of resource assignment with ease.
  • Data volume quota at schema level
    Efficiently manage the available disk space by limiting the maximal amount of raw data that can be used in a given schema.
  • Password Policies
    Increase the system security by enforcing password policies (e.g. password complexity, length, expiry).
  • Full disk prevention by query abort
    Identify and abort queries that may harm the system availability by utilizing too large amounts of temporary storage.
  • Switch to CentOS 7
    Upgrade the underlying operating system to CentOS 7 to ensure compatibility with future hardware and software components

With this version, there is no distinction between Advanced and Standard Edition anymore. All editions include: UDF and Scripting Support (Python, R, JAVA,Lua), Pluggable Language Support, Geospatial, Skyline, Virtual Schema, Advanced Import.

Tutorials

We are also making a series of videos available that present the new features and improvements in technical detail. What’s more, over the coming months we will be building out our online education materials. Version 6.1 tutorial videos can be viewed here: Exasol 6.1 User Portal

Exacademy Training

You can get certified with 6.1 using the new Exacadamy course which can be found here.

SQL Tools 

Starting with Exasol version 6.1, DbVisualizer Pro from DBVis is the recommended database tool for Exasol users, gradually replacing EXAplus GUI.

DbVisualizer

DbVisualizer is a universal database tool that has been optimized to support features and ways of working specific to Exasol and Exasol users. This is a joint effort by expert developers from Exasol and DbVis Software.

For version 6.0, EXAplus GUI will still be maintained. EXAplus 6.0 GUI is fully compatible with our Exasol database 6.1. Furthermore the Comand Line Version of EXAplus will still be maintained in all releases.

Additionally to DBVisualizer Pro, also a free DBVisualizer version is available that offers basic functionality. But for using all Exasol-specific features, you have to upgrade to the Pro Version using a license key acquired from DBVis.

Product page for DBVisualizer: https://www.dbvis.com/dbvisualizer-for-exasol/

Further alternative SQL tools with comprehensive Exasol support are DataGrip from Jetbrains and the open source tool DBeaver.

DataGrip

Commercial SQL Client with very good support for UDF developers. DataGrip is based on Jetbrain's powerfull IDE platform. (https://www.jetbrains.com/datagrip/)

DBeaver

OpenSource SQL Client with comprehensive support for Exasol (https://dbeaver.io/)


(info) Limited Campaign: Get a DBVisualizer Pro License for free!

Try out DBVisualizer Pro (eval. version available) and send us your feedback:

  • What do you like ?
  • What should be changed/added in future releases ?

You‘ll receive one DBVisualizer Pro License for free

Send your evaluation report by Jan 30th to: dbvisualizer@exasol.com

Important Notes

(warning) EXASOL 6.1.0 for AWS is released and Microsoft Azure will follow soon. Until then, please don't try to update an 6.0.x installation on AWS or Microsoft Azure to 6.1.0

(warning) Please carefully read the Changed Behavior section below before upgrading from 5.0.x and 6.0.x to 6.1.0

(warning) Keep in mind upgrading from 6.0.x needs to be done via an ISO upgrade or via a backup and restore. See Upgrade Guide.

Downloads

content type Affected Version/s download links
Loading...
Refresh


Changed Behavior

Implementing new features and improvements means that certain behavior that you may be used to in previous versions might have changed. Please review the following subset of issues from our change log. You can open the individual issues for more details. The full change log is listed further down on this page.

content type Summary changed behavior
Loading...
Refresh

Complete Change Log

content type Summary P
Loading...
Refresh