date: 2025-05-26
title: 'Spice v1.3.1 (May 26, 2025)'
type: blog
authors: [lukekim]
tags: [release, sql, databricks, parameterized queries]
Announcing the release of Spice v1.3.1! 🛡️
Spice v1.3.1 includes improvements to Databricks SQL Warehouse support and parameterized query handling, along with several bugfixes.
What's New in v1.3.1
-
Databricks SQL Warehouse Added support for the STRUCT type, enabled join pushdown for queries within the same SQL Warehouse and added projection to logical plans to force federation with correct SQL dialect.
-
SQL Improvements: Fixed an issue where ILike was incorrectly optimized to string equality in DataFusion/Arrow and aliased the random() function to rand() for better compatibility.
-
Parameterized Queries: Fixed parameter schema ordering for queries with more than 10 parameters and resolved placeholder inference issues in CASE expressions.
Contributors
Breaking Changes
No breaking changes.
Cookbook Updates
No new cookbook recipes.
The Spice Cookbook now includes 67 recipes to help you get started with Spice quickly and easily.
Upgrading
To upgrade to v1.3.1, use one of the following methods:
CLI:
Homebrew:
Docker:
Pull the spiceai/spiceai:1.3.1 image:
For available tags, see DockerHub.
Helm:
What's Changed
Dependencies
No major dependency changes.
Changelog
- Bump Helm chart to 1.3.0 by @phillipleblanc in #5925
- Fix Databricks SQL Warehouse benchmark test by @phillipleblanc, @lukekim, @kczimm, [@Spice Benchmark Snapshot Update Bot](https://github.com/Spice Benchmark Snapshot Update Bot) in #5924
- Add support for STRUCT type in Databricks SQL Warehouse by @kczimm, @lukekim in #5936
- Add projection to logical plan to force federation and correct dialect by @kczimm, @lukekim in #5946
- Allow join push down for same SQL Warehouse by @kczimm, @lukekim in #5947
- Avoid mistaken ILike to string equality optimization (DataFusion / Arrow) by @sgrebnov, @lukekim in #5939
- Make spill_to_disk_and_rehydration test more robust by @sgrebnov, @lukekim in #5929
- Alias the random() function to rand() by @phillipleblanc, @lukekim in #5967
- Fix parameter schema ordering with > 10 parameters for parameterized queries by @phillipleblanc, @lukekim in #5962
- Rev version to v1.3.1 by @lukekim in #5975
- Fix placeholder inference in CASE expressions by @phillipleblanc, @lukekim in #5968
Full Changelog: github.com/spiceai/spiceai/compare/v1.3.0...v1.3.1