|New Scalar Functions||
Two new functions are introduced in this release:
|Transport Layer Security (TLS) encryption for drivers||
Exasol JDBC, ODBC, and ADO.NET drivers now support TLS encryption. The feature also provides you an option to use fingerprints for the clients where certificate verification is not possible. To know more about the fingerprints, see Upload TLS Certificate.
If the certificate used by Exasol is not signed by a publicly recognized certificate authority (CA) or if the necessary CA certificate has not been provided to the client to use for verification, the connection will fail.
|JDBC 4.2 Support||Exasol's JDBC driver now supports JDBC 4.2 Core APIs.|
|Lua 5.4||Exasol 7.1 database comes with Lua 5.4. To know more about Lua 5.4, see Lua 5.4 Readme File.|
|Lua adapter scripts for Virtual Schema||Exasol now supports Lua adapter scripts for virtual schemas. This feature provides you better performance for regularly executed queries because it takes less time to start up. For more information, see CREATE SCRIPT, Database Interaction in Adapter Scripts, and Adapter Script Callback Function.|
|New Syntax in SQL Statements||
New syntax VALUES BETWEEN is introduced in INSERT and SELECT SQL statements.
Exasol now support OpenID token for the database user authentication. Exasol supports OpenID Connect Core 1.0 specification.
You can create or edit database users authenticated by OpenID using CREATE USER and ALTER USER. For more detail, see Authentication using OpenID.
|Snapshot Mode for SQL Statements||Exasol now supports snapshot execution of the SQL statements for queries to the system tables. For more details, see Snapshot Mode.|
|Query timeout attribute for consumer group||A new attribute QUERY_TIMEOUT is added to the consumer group. For more information, see CONSUMER GROUP and Consumer Group Attributes.|
|Idle timeout attribute for consumer group and system/ session parameters||A new attribute IDLE_TIMEOUT is added to the consumer group and system/ session parameter. For more information, see ALTER SYSTEM, ALTER SESSION, CONSUMER GROUP and Consumer Group Attributes.|
|Improved reordering of local filter expressions||Improved query performance by reordering cheaper local filter expressions first, if possible.|
|Improved performance of user, role and privileges system tables||
Query performance has been improved for the following system tables:
Speedup scales well with the size of these tables. The larger the number of concerned database objects, the more significant the speedup is.
|Control the number of UDF instance per UDF call to avoid query out-of-memory situations||
Exasol now provides you with an option to control the number of UDF instances per UDF Call per node to avoid query out-of-memory situations. For more information, see UDF Instance Limit per Node and UDF Call.
This feature is available for Java, Python, and R programming languages.
Python 2 is deprecated and will not be supported from next Exasol release. Therefore, Exasol recommends you to use Python 3 in all UDF's.