Skip to main content
Skip table of contents

1.7.8 (Released on July 6, 2020)

Overview

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

Easy to use

Developer Console SQL interface has been reworked to make it more legible and user-friendly. 

Easy to adopt

SET ALIAS command is available for creating an alias on a table in order to make queries more understandable. For instance, you could still use a table while inserting in another one with the same name.

Easy to implement 

Indexima now supports external tables on Apache Impala. It avoids copying data while maintaining a response time below a second.

With the external table sub-query function, Indexima can now delegate sub-queries to ensure a better integration with Dataviz tools.

Release Note for the Indexima version 1.7.8

In Details

Core

  • INDXMA-4603 (ZenD #443): Indexima now supports alias creation on a table.
  • INDXMA-4597 (ZenD #550): Indexima now supports command  SHOW TABLES in %used by Microsoft Power BI, which returns all tables from the current schema.
  • INDXMA-4674 : Pending time of a query is now stored in the file queries.csv log file.
  • INDXMA-4483 : In the Overview page of a table, the link for Power BI and MicroStrategy now redirects to the documentation on how to connect them to Indexima.
  • INDXMA-4449 : Add a new option master.socket.pool.size to increase performance on huge resultset queries on a cluster.
  • INDXMA-4704 : Add a new timeout option pending.timeout to cancel queries before they become eligible for a run.

External tables

  • INDXMA-4555 : Add support for Apache Impala as an external table.
  • INDXMA-4363 : Subqueries are now fully delegated instead of being rewritten before the delegation.
  • INDXMA-4568 : UNION and UNION ALL queries now support delegation.

Governance

  • INDXMA-4619 (ZenD #554 & #596): Add support for Hive variables on Hadoop 3.
  • INDXMA-4675 (ZenD #551): User can now see a schema if they have at least a SELECT privilege on one table of this schema, even if there is no privilege on the schema.
  • INDXMA-4624 : When navigating in pages of Monitor queries, history will not change if new queries are running in order to ease navigation and search for older queries.
  • INDXMA-4414 : Write operations won't be run on an index on error.
  • INDXMA-4574 : Add a new RANGER_CONF environment variable in galactica-env.sh to handle jaas.conf file for Solr.

Miscellaneous

  • INDXMA-4600 : Number of inserts for LOAD operations are now kept after a cluster reboot.
  • INDXMA-4490 : Indexima now allows table creation with an index's name starting with an underscore.
  • INDXMA-4478 (ZenD #527): Error in LOAD from JDBC are now displayed in Monitor queries.
  • INDXMA-4633 : Error message from bad SQL syntax has been rewritten to make them more understandable.
  • INDXMA-4601 : Load parameters SKIP and LIMIT now supports a value greater than 2 billion.

Bug Fixes

  • INDXMA-4593 (ZenD #527): SHOW TABLECOUNT could return the incorrect results with pre-join indexes
  • INDXMA-4593 (ZenD #527): classpath for the stop.sh script on Hadoop 3 with Zookeeper is wrongly set
  • INDXMA-4538 (ZenD #536): Deleted data are taken into account in case of join queries
  • INDXMA-4522 : SHOW CREATE TABLE command on a limited table doesn't create a limited table but an (unlimited) fact table
  • INDXMA-4480 (ZenD #527) : during a load in Indexima, the number of inserted lines is invalid when there are lines on error
  • INDXMA-4479 (ZenD #527): Incorrect results in a "Union ALL" query when a table has 2 main indexes
  • INDXMA-4702 (ZenD #594): Error message License expired while still valid.
JavaScript errors detected

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

If this problem persists, please contact our support.