Skip to main content
Skip table of contents

1.7.9 (Released on August 12th, 2020)


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


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


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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.