1.7.9 (Released on August 12th, 2020)

Overview

The version - V1.7.9 - of Indexima is now available.
This version offers new features :

A new load file assistant has been added to Indexima. It let you load your files without writing any SQL, from all your filesystems.

SQL Command COMPACT TABLE allows you to increase request throughput and reduce memory consumption when data is frequently deleted.
The startup time of an Indexima cluster has been reduced in order to raise updates and reboot.

Indexima now supports external tables on Oracle Database. It avoids copying data while maintaining a response time below a second.
External table support on Snowflake, Google BigQuery, and Apache Impala has been improved in order to support more functions and their parameters.

INDXMA-4771: Warehouse loading has been speeding up to reduce the duration of cluster unavailability during an upgrade or a restart
INDXMA-4766 (ZenD #604): Add support for field and expression in GROUP BY even if they are not in the SELECT clause.
INDXMA-4649: The SQL Dev Console UI has been reworked to be more user-friendly.
INDXMA-4608: Table creation now allows you to specify the timestamp.precision, instead of being global.

INDXMA-4821: Oracle Database is now supported as an external table.
INDXMA-4783: Queries support on Snowflake, Google BigQuery, and Apache Impala has been improved.
INDXMA-4839: File supported_dbs.json now allows you to add default JDBC parameters. This way, they will always be available when you create an external table from the wizard.
INDXMA-4836: SHOW CREATE TABLE now displays calculated fields.

INDXMA-4832: Reinit operation can be launched without reloading tables, leading to instant cluster availability.
INDXMA-4830: A load assistant has been added to the Dev Console. It lets you load your data without writing any SQL command.
INDXMA-4770: A new SQL instruction lets you compact your table. Compacting a table is useful when a lot of DELETE/LOAD operations have been run on it.

INDXMA-4795: Analyzer UI has been softly reworked to be more user-friendly.
INDXMA-4713 (ZenD #598): Parameters result.max_size and global.result.max_size now takes care of subqueries.
INDXMA-4703 (ZenD #590): Passwords are now hidden when the query has a parsing error.
INDXMA-4816: Parameter limit.select has been removed.
INDXMA-4852: Join computation memory consumption can now be limited to join.memory.max_size.

INDXMA-4842 (ZenD #630): Quotes on alias didn't support lowercase or uppercase
INDXMA-4793 (ZenD #620): In YARN deployment folders like ${sys:hive.log.dir} could be created at startup.
INDXMA-4650 (ZenD #523): In some cases, indexes are pickup when they shouldn't.