2022.2 (Released on May 25, 2022)
Overview
Indexima’s newest version – v2022.2 – is now available. This new version brings the following main new features:
Easy to use
Improve Load command with new parameters to handle Date (DATE_FORMAT), Timestamp (TIMESTAMP_FORMAT) and decimal formats (LOCALE).
Add new filters capabilities to the query listing, to improve query monitoring.
Easy to adopt
Internationalization: Better handle timezone in query logs in order to simplify query analysis in Indexima console whatever your localisation.
Easy To Implement
Optimize queries execution plan: Flatten fact/fact tables join in subqueries to accelerate query response time.
Improve management of temporary files to reduce risk of storage exhaustion.
Useful links
- Download version 2022.2 (Full version number is 2022.2.1737.x for service pack x)
- Migrate from 2022.1 to 2022.2
- Procedure for upgrading Indexima Core Engine (Galactica)
- Procedure for upgrading Indexima Console (VisualDoop2)
Detailed Release Note
Enhancements
- INDXMA-7426 (ZenD #1853 #1900): Improve startup warehouse check for CEPH
- INDXMA-7369: Prevent manual main index on dimension table
- INDXMA-7486 (ZenD #1977): Upgrade Snappy library
- INDXMA-7421 (ZenD #1808): Improve subqueries optimisation by removing unused fields
- INDXMA-7303: Refactoring ClientChannel usage
- INDXMA-2018 (ZenD #1702): Add DATE_FORMAT and TIMESTAMP_FORMAT options for load commands
- INDXMA-7398: Add TSV as export format
- INDXMA-7301: Improve thread management for storing plans
- INDXMA-7040: Clean deprecated projects endpoint in backend
- INDXMA-7386: Handle NULL for custom function (ascii, ceil, floor, length, like, round, next_day)
- INDXMA-7358: Handle NULL limitations on dates
- INDXMA-7330: Allow NULL from empty string during load
- INDXMA-7328: Add support for DEGREES / RADIANS / PI function
- INDXMA-3112: Update query logs architecture
- INDXMA-7467: Support AWS marketplace deploy on m5a
- INDXMA-7345: Create folder /galactica/ext for libraries extensions
Configuration
- INDXMA-7377: Remove nodes parameter
- INDXMA-7485 (ZenD #1970): Add NODESERVER_JVM_OPTIONS in stop.sh
- INDXMA-7476 (ZenD #1940): Remove parameter query.orderby.max_rows
- INDXMA-7425 (ZenD #1862): Remove deprecated status.sh
- INDXMA-7382: Extend timeout of new network stack
- INDXMA-7389: Remove warehouse.protocol and queries from galactica.conf.template
External tables
- INDXMA-7419: Error when delegating a Group by constant to snowflake
- INDXMA-7410: Error delegating unix_timestamp to Snowflake
- INDXMA-7470: Fix Impala external table edge cases
- INDXMA-7484 (ZenD #1959): Error on hive synchronize with index containing formula within a field (1)
- INDXMA-7498 (ZenD #1959): Error on hive synchronize with index containing formula within a field (2)
- INDXMA-7434 (ZenD #1869): Fix synchronize on hive external tables
Smart analyzer
- INDXMA-7359: Fix error Index cannot be created because it already exists
- INDXMA-7361: Analyzer missing queries with load balancing
- INDXMA-7495: Fix analyzer redirect to queries frame component
- INDXMA-7302: Fix analyzer error "Index won't be created because it already exists"
Console
- INDXMA-7166: WebSocket connection failed
- INDXMA-7463: Fix AWS marketplace error message on licence
- INDXMA-7427: Fix display issue when launching multiple analysis
- INDXMA-7388: Fix incorrect events display in query listing
- INDXMA-7374: Improve Drag bar in catalog
- INDXMA-7317: Improve search bar refresh on query listing
- INDXMA-7331: Handle every index when filtering on indexUsed
- INDXMA-7320: Node status heartbeat now reflects real status
- INDXMA-6273: New architecture for query listing endpoints
- INDXMA-7312: Clean deprecated projects endpoint
- INDXMA-7494: Log dates when cluster is reinitializing
- INDXMA-7488: Fix router on logs page
- INDXMA-7482: Add 'Loading more' message
- INDXMA-7475: Fix a frontend memory leak on query listing
- INDXMA-7473: Add query id in query listing
- INDXMA-7472: Hide License Page on market place
- INDXMA-7445: Add timestamp filter to query listing
- INDXMA-7373: Fix cancelled request when filtering queries
- INDXMA-7371: Add filter for cached queries
- INDXMA-6976: Remove the commit progress bar
- INDXMA-7436: Display rows count for operations UNION and SHOW
- INDXMA-7394: New query listing endpoints
Bugs
- INDXMA-7447: Fix critical race condition with Spill to Disk
- INDXMA-7446: Fix index_need_compaction computation
- INDXMA-7435: Fix Dateformat of MAX of date
- INDXMA-7430: Fix Ambiguous column name parsing error
- INDXMA-7428 (ZenD #1871): Drop alias is not persisted
- INDXMA-7423: Handle NULL in Having clause
- INDXMA-7414 (ZenD #1831): Fix implicit Join on sub select with DISTINCT or GROUP BY
- INDXMA-7409 (ZenD #1793): Fix incorrect implicit cast for timestamp fields as string
- INDXMA-7408 (ZenD #1693 #1815): Issue with mixed Timestamp Format in Dictionnary
- INDXMA-7406 (ZenD #1806): Fix error during truncate of DIM Table
- INDXMA-7397: Invalid dates in calendar when downloading diag on a Yarn cluster
- INDXMA-7396 (ZenD #1793): Fix incorrect implicit cast for date fields as string
- INDXMA-7393: Exception during pre-join computing if adding index on dim table
- INDXMA-7383 (ZenD #1899): Optimize growing eventsToPublish list
- INDXMA-7380 (ZenD #1785): Cache update issue between nodes
- INDXMA-7366: Schema appears again after a DROP SCHEMA
- INDXMA-7360: Error de-serializing history file
- INDXMA-7341: Boolean operator can return Null
- INDXMA-7338: Bool empty reference preventing index usage
- INDXMA-7333: SHOW TABLECOUNT stuck when big-index is enabled
- INDXMA-7332 (ZenD #1734): Fix empty result with join exchange
- INDXMA-7326: Fix load limit error handling
- INDXMA-7315 (ZenD #1704): Fix edge case of NullPointer error on large query left join
- INDXMA-7313 (ZenD #1617): Error downloading diagnostic if analysis directory is missing
- INDXMA-7006: ConcurrentModificationException during sub-request cleaning
Security
- INDXMA-7465 (ZenD #1919): Encrypt S3/CEPH credentials
- INDXMA-7413 (ZenD #1828 #1830): Monitor rights are not updated when logging off and switching users or cluster
- INDXMA-7412 (ZenD #1828 #1830): Prevent a non-admin user to edit connections