HEAVY.AI Docs
v9.0.0 (Latest)
v9.0.0 (Latest)
  • Welcome to HEAVY.AI Documentation
  • Overview
    • Overview
    • Release Notes
  • Installation and Configuration
    • System Requirements
      • Hardware Reference
      • Software Requirements
      • Licensing
    • Installation
      • Free Version
      • Installing on Docker
        • HEAVY.AI Installation using Docker on Ubuntu
      • Installing on Ubuntu
        • HEAVY.AI Installation on Ubuntu
        • Install NVIDIA Drivers and Vulkan on Ubuntu
      • Installing on Rocky Linux / RHEL
        • HEAVY.AI Installation on RHEL
        • Install NVIDIA Drivers and Vulkan on Rocky Linux and RHEL
      • Getting Started on AWS
      • Getting Started on GCP
      • Getting Started on Azure
      • Getting Started on Kubernetes (BETA)
      • Upgrading
        • Upgrading HEAVY.AI
        • Upgrading from Omnisci to HEAVY.AI 6.0
        • CUDA Compatibility Drivers
      • Uninstalling
      • Ports
    • Services and Utilities
      • Using Services
      • Using Utilities
    • Executor Resource Manager
    • Configuration Parameters
      • Overview
      • Configuration Parameters for HeavyDB
      • Configuration Parameters for HEAVY.AI Web Server
      • Configuration Parameters for HeavyIQ
    • Security
      • Roles and Privileges
        • Column-Level Security
      • Connecting Using SAML
      • Implementing a Secure Binary Interface
      • Encrypted Credentials in Custom Applications
      • LDAP Integration
    • Distributed Configuration
  • Loading and Exporting Data
    • Supported Data Sources
      • Kafka
      • Using HeavyImmerse Data Manager
      • Importing Geospatial Data
    • Command Line
      • Loading Data with SQL
      • Exporting Data
  • SQL
    • Data Definition (DDL)
      • Datatypes
      • Users and Databases
      • Tables
      • System Tables
      • Views
      • Policies
      • Comment
    • Data Manipulation (DML)
      • SQL Capabilities
        • ALTER SESSION SET
        • ALTER SYSTEM CLEAR
        • DELETE
        • EXPLAIN
        • INSERT
        • KILL QUERY
        • LIKELY/UNLIKELY
        • SELECT
        • SHOW
        • UPDATE
        • Arrays
        • Logical Operators and Conditional and Subquery Expressions
        • Table Expression and Join Support
        • Type Casts
      • Geospatial Capabilities
        • Uber H3 Hexagonal Modeling
      • Functions and Operators
      • System Table Functions
        • generate_random_strings
        • generate_series
        • tf_compute_dwell_times
        • tf_feature_self_similarity
        • tf_feature_similarity
        • tf_geo_rasterize
        • tf_geo_rasterize_slope
        • tf_graph_shortest_path
        • tf_graph_shortest_paths_distances
        • tf_load_point_cloud
        • tf_mandelbrot*
        • tf_point_cloud_metadata
        • tf_raster_contour_lines; tf_raster_contour_polygons
        • tf_raster_graph_shortest_slope_weighted_path
        • tf_rf_prop_max_signal (Directional Antennas)
        • ts_rf_prop_max_signal (Isotropic Antennas)
        • tf_rf_prop
      • Window Functions
      • Reserved Words
      • SQL Extensions
      • HeavyIQ LLM_TRANSFORM
  • HeavyImmerse
    • Introduction to HeavyImmerse
    • Admin Portal
    • Control Panel
    • Working with Dashboards
      • Dashboard List
      • Creating a Dashboard
      • Configuring a Dashboard
      • Duplicating and Sharing Dashboards
    • Measures and Dimensions
    • Using Parameters
    • Using Filters
    • Using Cross-link
    • Color Consistency
    • Chart Animation
    • Multilayer Charts
    • SQL Editor
    • Customization
    • Joins (Beta)
    • Chart Types
      • Overview
      • Box/Whisker and Violin Plots
      • Bubble
      • Choropleth
      • Combo
      • Contour
      • Cross-Section
      • Gauge
      • Geo Heatmap
      • Heatmap
      • Linemap
      • Number
      • Pie
      • Pointmap
      • Scatter Plot
      • Skew-T
      • Table
      • Text Widget
      • Wind Barb
    • Deprecated Charts
      • Bar
      • Combo - Original
      • Histogram
      • Line
      • Stacked Bar
    • HeavyIQ SQL Notebook
  • HEAVYIQ Conversational Analytics
    • HeavyIQ Overview
      • HeavyIQ Guidance
    • HeavyIQ Model Overview (HeavyLM)
  • HeavyRF
    • Introduction to HeavyRF
    • Getting Started
    • HeavyRF Table Functions
  • HeavyConnect
    • HeavyConnect Release Overview
    • Getting Started
    • Best Practices
    • Examples
    • Command Reference
    • Parquet Data Wrapper Reference
    • ODBC Data Wrapper Reference
    • Raster Data Wrapper Reference
  • HeavyML (BETA)
    • HeavyML Overview
    • Clustering Algorithms
    • Regression Algorithms
      • Linear Regression
      • Random Forest Regression
      • Decision Tree Regression
      • Gradient Boosting Tree Regression
    • Principal Components Analysis
  • Python / Data Science
    • Data Science Foundation
    • JupyterLab Installation and Configuration
    • Using HEAVY.AI with JupyterLab
    • Python User-Defined Functions (UDFs) with the Remote Backend Compiler (RBC)
      • Installation
      • Registering and Using a Function
      • User-Defined Table Functions
      • RBC UDF/UDTF Example Notebooks
      • General UDF/UDTF Tutorial Notebooks
      • RBC API Reference
    • Ibis
    • Interactive Data Exploration with Altair
    • Additional Examples
      • Forecasting with HEAVY.AI and Prophet
  • APIs and Interfaces
    • Overview
    • heavysql
    • Thrift
    • JDBC
    • ODBC
    • Vega
      • Vega Tutorials
        • Vega at a Glance
        • Getting Started with Vega
        • Getting More from Your Data
        • Creating More Advanced Charts
        • Using Polys Marks Type
        • Vega Accumulator
        • Using Transform Aggregation
        • Improving Rendering with SQL Extensions
      • Vega Reference Overview
        • data Property
        • projections Property
        • scales Property
        • marks Property
      • Migration
        • Migrating Vega Code to Dynamic Poly Rendering
      • Try Vega
    • RJDBC
    • SQuirreL SQL
    • heavyai-connector
  • Tutorials and Demos
    • Loading Data
    • Using Heavy Immerse
    • Hello World
    • Creating a Kafka Streaming Application
    • Getting Started with Open Source
    • Try Vega
  • Troubleshooting and Special Topics
    • FAQs
    • Troubleshooting
    • Vulkan Renderer
    • Optimizing
    • Known Issues and Limitations
    • Logs and Monitoring
    • Archived Release Notes
      • Release 7.x
      • Release 6.x
      • Release 5.x
      • Release 4.x
      • Release 3.x
Powered by GitBook
On this page
  • Release 9.0.0
  • HeavyDB - New Features & Improvements
  • HeavyDB - Fixed Issues
  • HeavyImmerse - New Features & Improvements
  • HeavyImmerse - Fixed Issues
  • Release 8.x.x
  • Release 8.5.2
  • HeavyDB - Fixed Issues
  • Heavy Render - New Features and Improvements
  • Heavy Render - Fixed Issues
  • HeavyImmerse - Fixed Issues
  • HeavyIQ / HeavyLM Fixed Issues
  • Release 8.5.1
  • HeavyImmerse - Fixed Issues
  • Release 8.5.0
  • HeavyImmerse - New Features and Improvements
  • HeavyImmerse - Fixed Issues
  • Heavy Render - New Features and Improvements
  • Release 8.4.0
  • General
  • HeavyDB - New Features and Improvements
  • HeavyDB - Fixed Issues
  • Release 8.3.2
  • HeavyImmerse - New Features and Improvements
  • HeavyImmerse - Fixed Issues
  • Release 8.3.1
  • HeavyImmerse - Fixed Issues
  • Release 8.3.0
  • HeavyDB - New Features and Improvements
  • HeavyDB - Fixed Issues
  • HeavyImmerse - New Features and Improvements
  • Release 8.2.0
  • HeavyDB - New Features and Improvements
  • HeavyDB - Fixed Issues
  • HeavyImmerse - Fixed Issues
  • Release 8.1.2 (RHEL) & 8.1.3 (Ubuntu)
  • HeavyDB - New Features and Improvements
  • HeavyDB - Fixed Issues
  • HeavyImmerse - Fixed Issues
  • HeavyIQ / HeavyLM - New Features and Improvements
  • HeavyIQ / HeavyLM - New Features and Improvements
  • Release 8.1.1
  • HeavyDB - New Features and Improvements
  • HeavyDB - Fixed Issues
  • HeavyImmerse - New Features and Improvements
  • HeavyImmerse - Fixed Issues
  • Heavy IQ / HeavyLM - New Features and Improvements
  • HeavyIQ / HeavyLM - Fixed Issues
  • Release 8.1.0
  • HeavyDB - New Features and Improvements
  • HeavyDB - Fixed Issues
  • HeavyRender - New Features and Improvements
  • HeavyRender - Fixed Issues
  • HeavyImmerse - New Features and Improvements
  • HeavyImmerse - Fixed Issues
  • HeavyIQ / HeavyLM - New Features and Improvements
  • Release 8.0.2
  • HeavyIQ / HeavyLM - New Features and Improvements
  • HeavyIQ / HeavyLM - Fixed Issues
  • Release 8.0.1
  • HeavyDB - New Features and Improvements
  • HeavyDB - Fixed Issues
  • HeavyRender - Fixed Issues
  • Heavy Immerse - New Features and Improvements
  • Heavy Immerse - Fixed Issues
  • HeavyIQ / HeavyLM - New Features and Improvements
  • Release 8.0.0
  • HeavyDB - New Features and Improvements
  • HeavyDB - Fixed Issues
  • Heavy Render - New Features and Improvements
  • Heavy Render - Fixed Issues
  • Heavy Immerse - New Features and Improvements
  • Heavy Immerse - Fixed Issues
  • HeavyIQ Conversational Analytics
Export as PDF
  1. Overview

Release Notes

Release notes for currently supported releases

PreviousOverviewNextSystem Requirements

Last updated 24 days ago

Use of HEAVY.AI is subject to the terms of the .

Currently Supported Releases

| | | | | | | | | | | | |

For release notes for releases that are no longer supported, as well as links to documentation for those releases, see .

As with any software upgrade, it is important to back up your data before you upgrade HEAVY.AI. In addition, we recommend testing new releases before deploying in a production environment.

For assistance during the upgrade process, contact HEAVY.AI Support by logging a request through the .

Release 9.0.0

HeavyDB - New Features & Improvements

  • A configuration parameter for setting the maximum number of GPUs per concurrent query execution.

  • Support for Parquet import and HeavyConnect of POINT geometry columns from separate longitude and latitude columns.

  • Add zip compression support for shapefile export.

  • Export date columns to shapefiles as OFTDate instead of string.

  • A configuration parameter that allows exporting timestamps in non-ISO format.

  • Support for accelerated bidirectional CPU/GPU data transfers using pinned memory jump buffers.

  • Optimize queries that project variable (non-fixed) length column expressions.

  • Add H3_CellToPoint SQL function and H3_CellToBoundary_POLYGON SQL function.

HeavyDB - Fixed Issues

  • A crash that could occur when tables are reordered for queries with ST function join predicates and multiple column projections.

  • Issue where H3_CellToBoundary_WKT SQL functions did not return closed polygon rings.

  • A crash that could occur when other ST SQL function calls are nested within ST_NPoints or ST_NRings function calls.

HeavyImmerse - New Features & Improvements

  • New default chart type - Box and Whisker/Violin Plot

  • Update Text and Text2 chart types to sanitize input and prevent javascript execution with custom code

  • Add binary multi-byte units to the “Number Formatting” options list

  • Add Shapefile and FlatGeoBuf export options for map charts

  • Enable ENABLE_GLOBAL_CUSTOM_SQL feature flag by default

HeavyImmerse - Fixed Issues

  • Crash that can occur with certain combo chart configurations where # Records aggregate was set for both size and color measure

Release 8.x.x

IMPORTANT - In HeavyDB Release 8.x.x, the system catalog is automatically migrated to support the new Column Level Security feature. This migration is necessary regardless if you intend to use this feature or not. Once the system catalog has been migrated in this manner, it is not backwards-compatible with earlier versions of HeavyDB. If you revert to an earlier version in this state, the system will be in an unstable state and manual intervention will be required. We recommend backing up your data before you upgrade HEAVY.AI.

8.x.x introduces a new licensing version that feature two new types of licenses: Node Locked Licenses and Floating Licenses. Enterprise customers that are upgrading to the 8.x release of HEAVY.AI are required to reach out to the HEAVY.AI Customer Success team for a new license before attempting to upgrade.

Release 8.5.2

HeavyDB - Fixed Issues

  • Fixes a race condition that could occur when concurrently accessing the memory_summary and memory_details system tables.

  • Fixes an intermittent crash that could occur for join queries with row-level security enabled.

  • Fixes a crash that could occur for certain query patterns involving the IN operator and subqueries with text projections.

  • Fixes a crash that could occur when the APPROX_PERCENTILE function is called with invalid arguments.

Heavy Render - New Features and Improvements

  • Improved logging around renderer device initialization and clean up

Heavy Render - Fixed Issues

  • Fix for intermittent server crash when restarting the renderer after a CPU out-of-memory event

HeavyImmerse - Fixed Issues

  • Combo chart with group by dimension displaying incorrect values in legend

HeavyIQ / HeavyLM Fixed Issues

  • Fix chromadb index creation bug and added support for importing faiss module on master process

Release 8.5.1

HeavyImmerse - Fixed Issues

  • Crossfiltering a chart with a non-joined data source did not refresh a chart with a joined datasource

  • Adjusting chart-level filters via the notch menu on a dashboard caused the chart to crash

Release 8.5.0

HeavyImmerse - New Features and Improvements

  • Add ruler control to raster map charts and Esc key to close ruler control

  • Color all values - Colors an unlimited number of categorical values in raster charts using a hash function. Defaults to on, but can be turned off to access legacy coloring mode (coloring by top k)

  • Column names as export headers - Updates export logic to use column names as headers in the export file instead of names like measure0, dimension1; for the following charts: table, combo, pointmap, scatterchart, bubble chart, pie chart, heat

  • Scatter chart export - Implements data export for scatter plots and uses column names as export headers

  • Log scale axis - Implements log scale option for combo and scatter chart Y-axis

  • Infinite scrolling legend - Only active when “Color All Values” is on, allows the user to continually scroll the legend, automatically loading more values at the end of the scroll.

HeavyImmerse - Fixed Issues

  • Parameter change (in custom SQL filter) not updating table chart

Heavy Render - New Features and Improvements

  • Improve logged statistics whenever rendering errors occur

Release 8.4.0

General

  • ARM support (including NVIDIA Grace Hopper) - Docker install only

  • RHEL/Rocky 8 support - bare metal install only

HeavyDB - New Features and Improvements

  • Adds new Uber H3 functions and removes existing deprecated functions

  • Change how the GEOs library path is specified for use by some geospatial functions

  • Update CPU join hash tables to use the "cpu-buffer-mem-bytes" configured CPU memory buffer pool for memory allocations

HeavyDB - Fixed Issues

  • Fixes a crash that could occur when a subquery within an IN clause references a non-existent column

  • Fixes a race condition that could occur when disk level caching is enabled for non-foreign tables

Release 8.3.2

HeavyImmerse - New Features and Improvements

  • RTL Text support in mapbox basemap labels

HeavyImmerse - Fixed Issues

  • Fix for shows the palette selector in combo chart when “# Records” is selected as a color measure

Release 8.3.1

HeavyImmerse - Fixed Issues

  • Fixes a crash when loading older dashboards, or instances and dashboards with customized/removed color palettes with new color consistency feature.

  • Fix for render error on multilayer raster charts that use new color mapping features.

  • Fix for render error when switching chart types while using new color mapping features.

  • Fix for bubble chart crash when using numeric dimension.

  • Fix for legends not showing in combo chart for continuous measures with no color measure selected.

Release 8.3.0

HeavyDB - New Features and Improvements

  • Optimizes concurrent access and caching of table data during query execution.

  • Optimizes string dictionary memory allocations

  • Adds a validation to ensure that raster import/HeavyConnect with floating point coordinate types are either world or file space transformed.

HeavyDB - Fixed Issues

  • Fixes a crash that could occur when attempting to import or HeavyConnect to Apache Spark generated empty Parquet files.

  • Fixes a crash that could occur when attempting to import or HeavyConnect to Parquet files containing Null columns.

  • Fixes a potential race condition that could occur when the Executor Resource Manager is enabled.

  • Fixes an exception that could occur for log based system tables when the log directory contains unexpected files.

HeavyImmerse - New Features and Improvements

  • Support for customizable color mappings across charts, including Combo, Pointmap, Linemap, Choropleth, Scatterplot, Pie, and Bubble, enabling consistent and tailored color schemes for enhanced visual control. Users can create, import, manage, and apply mappings, with options to save changes, delete mappings, or reset to default hash coloring as needed.

  • Uses Hash Coloring to ensure consistent color assignment for the same column values across all charts and dashboards.

  • Unified, default Categorical Colors palette is now used across all supported charts, ensuring out-of-the-box consistency in visualizations.

  • The previous "Color Set 2" palette has been integrated into the Categorical Colors palette set to streamline options and reduce confusion.

Release 8.2.0

HeavyDB - New Features and Improvements

  • ARM support

  • Security updates and fixes

HeavyDB - Fixed Issues

  • Fixes a crash that could occur when executing queries against ODBC backed foreign tables with negative decimal column values.

HeavyImmerse - Fixed Issues

  • Updated web server dependencies to improve security

Release 8.1.2 (RHEL) & 8.1.3 (Ubuntu)

HeavyDB - New Features and Improvements

  • Improves memory utilization for queries with APPROX_COUNT_DISTINCT function calls

  • Significantly faster columnarization of "lazy fetched" result set data for multi-step queries

  • Significantly faster string operations, particularly for high-cardinality string inputs (3X+ speedups in some cases)

HeavyDB - Fixed Issues

  • Fixes an error where users without column level privileges could not access views

  • Fixes a crash that could occur for queries that order by none encoded text expressions

  • Fixes an issue where wrong results could be returned for repeated queries with joins on encoded text column expressions

  • Fixes an error that could occur when large integer values are used in row level security policies

  • Fixes a CUDA 700 crash that could occur for left join queries with geospatial function predicates

HeavyImmerse - Fixed Issues

  • Fix side panel overlay issue for time-picking filter.

HeavyIQ / HeavyLM - New Features and Improvements

  • Allow support for Guidance without an embedding server.

  • Support FAISS as an alternative to ChromaDB for embeddings.

HeavyIQ / HeavyLM - New Features and Improvements

  • Various minor improvements and enhancements

Release 8.1.1

HeavyDB - New Features and Improvements

  • Improves memory management for import requests

  • Improves performance of group by queries through expanded use of shared memory

  • Improves performance of low cardinality group by queries

  • Improves performance of queries with sort on encoded string column expressions

  • Improves performance of result set reductions

  • Optimizes memory utilization and performance for sort queries

  • Adds more instrumentation around memory utilization

  • Adds support for ST_Centroid function calls with MULTILINESTRING column type arguments

HeavyDB - Fixed Issues

  • Fixes an issue where S3 imports would not roll back correctly in certain error cases

  • Fixes an error where repetition of certain geo join queries could result in excessive memory utilization

HeavyImmerse - New Features and Improvements

  • Make Dashboard configuration panel resizeable.

  • Add UI customization options for Cloud Edition.

HeavyImmerse - Fixed Issues

  • Fix scrolling bug with Guidance Snippet list.

  • Improve handling for loading a database with no tables.

  • Fix map points display issue on first render.

Heavy IQ / HeavyLM - New Features and Improvements

  • Add support for a vLLM Embedding server.

HeavyIQ / HeavyLM - Fixed Issues

  • Fix ChromaDB configuration issues.

Release 8.1.0

HeavyDB - New Features and Improvements

  • Adds support for bounding box clipping when importing geospatial files

  • Retries estimation queries on CPU if the initial query execution fails on GPU due to out of memory errors

  • Improves the error message that is logged when table data file reads result in errors

HeavyDB - Fixed Issues

  • Fixes a crash that could occur when Parquet backed foreign tables reference incompatible files

  • Fixes an issue where spatial transforms were not applied correctly for some raster files containing sub-datasets

  • Fixes an issue where some string functions would result in error responses when used in predicates and update and delete queries

HeavyRender - New Features and Improvements

  • Significantly reduced GPU render memory usage and improved performance when rendering complex polygon data

  • Internal restructuring laying groundwork for improved concurrency between HeavyDB and Heavy Render

HeavyRender - Fixed Issues

  • Fixed an issue where some GPUs would fail to identify a useful GPU memory heap reporting 0 available memory

  • Fixed a crash that could occur if a table involved in a query is removed between a render and a later hit-test query (mouse rollover in Immerse)

  • Fixed a crash that could occur during renderer shutdown and restart if an out of GPU memory error occurs during certain buffer allocation operations

HeavyImmerse - New Features and Improvements

  • Manage Table and Column Comments in Data Manager

  • Immerse theming control panel

  • Add alternative geocoder support using custom location list from a CSV

  • Add support for custom AWS Regions

HeavyImmerse - Fixed Issues

  • Fix layer ordering label change after layer switching

  • Fixed the addition of the last categorical color not being used in color by measure

  • Make SQL Notebook line charts use GMT instead of local timezone

HeavyIQ / HeavyLM - New Features and Improvements

  • Added Column Preview summarizing for columns in SQL Notebook source list.

  • New Log File viewing for IQ Startup and IQ Build log tiles

  • Improvements to SQL Notebook UI

  • BETA: Added the new Guidance feature in the HeavyIQ SQL Notebook, powered by HeavyLM's advanced LLM service, provides contextual recommendations and real-time insights for optimized query generation and analysis.

  • Improved the SQL tool with optimized top-k calculations for string columns, adjusted default settings for cardinality thresholds, and added support for multiline comments in schema caching.

Release 8.0.2

HeavyIQ / HeavyLM - New Features and Improvements

  • Improve runtime support for Python versions > 3.10.

HeavyIQ / HeavyLM - Fixed Issues

  • Various performance improvements and fixes.

Release 8.0.1

HeavyDB - New Features and Improvements

  • Relaxes Coordinate Reference System validations that occur on geospatial data import.

HeavyDB - Fixed Issues

  • Fixes an issue where cross database queries could result in use of incorrect string dictionaries.

  • Fixes an issue where Host IDs could not be generated on OCI instances.

  • Fixes an issue where database switching resulted in errors on certain server configurations.

  • Fixes a CUDA 700 crash that could occur due to incorrect internal caching.

  • Fixes a parsing error that could occur when projecting array literals with the same element data types.

  • Fixes an issue where updates via subqueries with non unique rows could result in the wrong error message.

  • Fixes a crash that could occur when using the CARDINALITY function in certain cases.

  • Fixes a crash that could occur for certain query patterns involving casts to a REAL data type.

  • Fixes a crash that could occur for queries with certain case expression patterns involving DATE data types.

  • Fixes a crash that could occur in certain cases where resultset caching is enabled.

  • Fixes a crash that could occur for queries that specify LIMIT clauses with floating point values.

  • Fixes an issue where sql_validate requests with queries containing WIDTH_BUCKET function calls with subquery arguments can result in an error.

  • Fixes a crash that could occur for certain query patterns with subqueries that include LIMIT and/or OFFSET clauses.

HeavyRender - Fixed Issues

  • Fix to return null hit-test result if not found.

  • Fixed an 8.0.0 issue with render gpu selection that would trigger a crash when using the start-gpu program option

  • Fixed a rare 8.0.0 issue with free GPU memory detection on systems with resizable BAR enabled

Heavy Immerse - New Features and Improvements

  • Enable HeavyIQ SQL Notebook for Free Edition.

Heavy Immerse - Fixed Issues

  • Fix to show “Column not found” error text in a raster chart pop-up instead of crashing chart when hit-test column is not found.

  • Fix for crossfiltering of Number chart when filtering on a Combo chart with a custom SQL base dimension.

  • Change feature flag from “ui/hide_charts_headers” to “ui/hide_text_chart_headers” and only hide headers on Text charts.

  • Fix to set priority colors in Pointmap charts.

  • Update categorical legend domain on map chart zoom.

  • Fixes regression with prioritized color layers.

HeavyIQ / HeavyLM - New Features and Improvements

  • Enable HeavyIQ for Free Edition.

  • Improved caching and processing of table and column metadata.

Release 8.0.0

8.0.0 introduces a new licensing version that feature two new types of licenses: Node Locked Licenses and Floating Licenses. Enterprise customers that are upgrading to the 8.0.0 release of HEAVY.AI are required to reach out to the HEAVY.AI Customer Success team for a new license before attempting to upgrade.

HeavyDB - New Features and Improvements

  • SELECT privileges are now required in order to execute UPDATE or DELETE commands.

  • Adds a new "columns" system table that contains information about all table columns across all databases.

  • Adds support for foreign tables that are backed by raster files.

  • Adds a new raster import mechanism that stores raster data in a tiled format. This can be enabled by setting the "enable-legacy-raster-import" HeavyDB server configuration parameter to false.

  • Adds support for column level SELECT privileges.

  • Adds support for comments on tables.

  • Adds support for comments on columns.

  • Adds support for null value filtering on raster import.

  • Adds MULTIPOLYGON to MULTIPOLYGON ST_Contains function support.

  • Improves performance for certain query patterns with BETWEEN predicate clauses.

  • Enables the "use-cpu-mem-pool-for-output-buffers" HeavyDB server configuration parameter by default.

  • Updates the default value for the "ndv-group-estimator-multiplier" HeavyDB server configuration parameter.

HeavyDB - Fixed Issues

  • Fixes a crash that could occur in the load_table_binary_columnar Thrift API when request payloads are malformed.

  • Fixes a crash that could occur in the detect_column_types Thrift API when an uneven number of levels across columns are read for Parquet files.

  • Fixes a crash that could occur in certain cases where Parquet files are imported from S3 with debug timers enabled.

  • Fixes a race condition that could occur with foreign table scheduled refreshes.

  • Fixes a crash that could occur when the ST_NPoints function is called with literal arguments.

  • Fixes a hang that could occur when a "clear CPU" or "clear GPU" request is made after the Executor Resource Manager returns an error response for a previous query.

  • Fixes an issue where certain sorted join query patterns could return wrong results.

  • Fixes an intermittent "Ran out of slots in the query output buffer" error that could occur due to incorrect reuse of the cardinality cache for similar queries.

  • Fixes a crash that could occur in certain cases where the null value results from the ST_Centroid function are passed in as arguments to other ST functions.

  • Fixes use cases where the Executor Resource Manager did not account for result set buffers that are allocated through the CPU buffer pool.

  • Fixes an issue where the use of the approx_count_distinct function could cause a slowdown for certain query patterns in distributed configurations.

  • Fixes an issue where wrong results could be returned due to an overflow when dividing two decimals.

  • Fixes a crash that could occur for certain query patterns with Common Table Expressions that project point columns.

  • Fixes a crash that could occur for queries that specify LIMIT clauses with floating point values.

  • Fixes a crash that could occur for certain cases where the output of an ST function is passed in as an argument to the ST_Contains function.

  • Fixes an issue where the ST_Distance function can return wrong results for cases where a polygon encloses another polygon.

Heavy Render - New Features and Improvements

  • Shader compiler optimizations.

  • Increased default res-gpu-mem value from 385Mb to 768Mb.

Heavy Render - Fixed Issues

  • Fixed shader compiler error when combining symbol rotation and accumulation.

  • Catch failed render result buffer allocations and throw an out of GPU memory error.

  • Fixed an issue that could cause a Cuda Error 700.

  • Fixes a crash that could occur for render requests containing certain sort query patterns.

Heavy Immerse - New Features and Improvements

  • Introducing the SQL Notebook in Immerse, which in addition to supporting a notebook view of query history, allows inline visualization of query results using bar charts, line charts, scatterplots, heatmaps, choropleths, and pointmaps. The SQL notebook also integrates directly with the HeavyIQ conversational analytics module, allowing you to ask questions of your data in natural language, returning visualizations, natural language answers, and tabular results along with the generated SQL. The new SQL notebook is off by default, but it can be enabled by setting "dev/enable_notebook_ui_sql_editor": true in the servers.json file.

  • Viridis, Turbo, and Plasma added as new color palettes.

Heavy Immerse - Fixed Issues

  • Fixes dropping of filter clauses from SQL on exiting dash panel edit mode.

  • Fixes cross-filtering on Number chart when filtering on a Vega Combo chart with a custom SQL base dimension.

  • Fixed regression for enabling feature flag “ui/enable_chart_filter_view".

  • Fixed dashboard loading error when switching tabs with a HeavyDB error present.

  • Fixed joined table referenced in a size measure on the Line Map chart.

  • Fixed issue with non-integer operands in modulo operation error for Contour chart.

  • Fixed issue with color range display of filtered values for the Contour chart.

  • Fixed code generation for order of evaluation in map charts using SAMPLE_RATIO.

  • Fixed issue with Pointmap rendering of filtered data.

  • Fixed various minor display and styling issue.

HeavyIQ Conversational Analytics

  • HeavyIQ Conversational Analytics allows users to ask questions of their data using natural language by leveraging a custom Large Language Model (LLM) that has been fine-tuned on over 60,000+ training pairs to provide state-of-the-art performance on text-to-sql and other data analytics tasks. HeavyIQ requires no external API calls and guarantees data privacy by virtue of being a fully offline model.

  • The primary interface point for the new HeavyIQ conversational analytics capabilities are via the new SQL editor (see above), but it can also be utilized via API if desired.

Added operator, allowing access to large language model inference within SQL

Adds support for a function with array parameters, which can be used to compute the similarity between arrays (vectors)

HEAVY.AI End User License Agreement (EULA)
9.0.0
8.5.2
8.5.1
8.5.0
8.4.0
8.3.2
8.3.1
8.3.0
8.2.0
8.1.2 & 8.1.3
8.1.1
8.0.2
8.0.1
8.0.0
Archived Release Notes
HEAVY.AI Support Portal
LLM_TRANSFORM
DOT_PRODUCT