1.7.6 (Released on March 26th, 2020)
Overview
- Optimize Table button allows you - in one click - to create and remove HyperIndexes on each of your tables in order to keep the best possible optimization.
- Overview Table offers you a total view of table metadata (number of rows, memory footprint, disk utilization, ...) in one page.
Indexima is available on AWS marketplace. In a few clicks, Zero Time To Data is available (instantiate, data connection, data visualization integration).
The new Wizard Create Table will now assist you in the creation of your Indexima tables.- Dataviz Connection button gives you the possibility to connect in one click to the data visualization tools (ex. TDS).
Release Note for the INDEXIMA version 1.7.6
In details
Easy to use
- INDXMA-4033 : Table now has an overview page that summarizes informations about it.
- INDXMA-3886 : Overview page and notification panel have a new Optimize button that will create and delete your indexes accordingly to your needs, without having to go to the Analyzer page.
- INDXMA-3699 : Add a CASCADE option for DROP TABLE that will drop associated views of the table.
- INDXMA-3788 : Add support for RAND and RANDOM functions.
- INDXMA-4104 : TOP indexes now supports 2 ORDER BY clauses for the GROUP BY column and the aggregate.
Easy to adopt
- INDXMA-3944 : Wizard Create Table in Developer Console to assist you in the creation of your Indexima tables.
- INDXMA-3362 : Add support for managing Indexima clusters through Developer Console on Amazon Web Services.
- INDXMA-4029: Add new command CREATE USER and DROP USER.
- INDXMA-4107 : Add support for admin role, with the same privileges as Hive does.
- INDXMA-3917 : Add a new MONITOR_LOG role.
Easy to implement
- INDXMA-3948 : Overview page has a Dataviz Connection Tools button that lets you download a TDS file to instantly open and connect Tableau Software to this table.
- INDXMA-3458 : Add support for Hive deflate format in load operation.
- INDXMA-3561 : Support of Google BigQuery as external tables for simple usecases.
Miscellaneous
- INDXMA-4122 : More detailed logs in case of a JDBC load that may time out if the database is stuck.
Parameter jdbc.load.tasks has been removed. - INDXMA-3971 : Improve filtering with join on constant, resulting on faster queries.
- INDXMA-3908 : Table name is mentioned in query logs for LOAD operation.
- INDXMA-3849 : Integer functions (like YEAR) that receive NULL parameter returns NULL instead of 0.
- INDXMA-3844 : Better support of date function with integer and double that could return NULL.
- INDXMA-3745 : Better computation of memory size for dictionaries.
Bug fixes
- INDXMA-4077 : Fixed an issue where an ORDER BY clause could return rows not sorted in the specified order.
- INDXMA-4156 : DESCRIBE on a View shows fields from the underlying table, not the view.
- INDXMA-3705 : SHOW SCHEMA command now supports Ranger.
- INDXMA-4099 : Fixed an issue where a JOIN on a view over a dimension table could lead to incorrect results.
- INDXMA-3917 : Fixed an issue where multiple JOIN clause could lead to a failed query.
- INDXMA-3881 : Column in view doesn't handle upper case.
- INDXMA-2344 : Addressed an issue where a division between 2 integers was rounded into an integer, instead of a double.
Configuration changes
Two new configuration files (Don't forget to rename the files without the .template extension)
- supported_dbs.json
- optimize_table.json.
Deprecated parameters
- jdbc.load.tasks
- jdbc.load.nbThreads