1.7.9 (Released on August 12th, 2020) ​

Overview ​

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

Easy to use ​

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

Easy to adopt ​

  • 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.

Easy to implement ​

  • 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.

Release Note for the Indexima version 1.7.9 ​

In Details ​

Core ​

  • 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.

External tables ​

  • 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.

Governance ​

  • 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.

Miscellaneous ​

  • 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.

Bug Fixes ​

  • 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.