r/redis • • 15h ago

News Redis SQL Trino 0.4.3: query Redis with SQL, connect BI tools, and join across data sources

3 Upvotes

Hi r/redis — we’ve released Redis SQL Trino 0.4.3.

If you haven’t come across the project, it’s an open-source connector that lets Trino query Redis HASH and JSON data indexed by Redis Query Engine using SQL. Applications and BI tools can connect through Trino’s JDBC interface, and you can join Redis data with other sources supported by Trino.

For example, you could query operational data in Redis from a SQL client or combine it with warehouse data without first copying everything into the warehouse.

The recent work has focused on broader SQL support, correctness, and reducing how much data moves from Redis to Trino. This release includes:

  • More SQL features: ordinary views, table and column comments, column positioning, and TRUNCATE.
  • Better query execution: more eligible filters, counts, DISTINCT counts, grouping, and ORDER BY … LIMIT work handled closer to Redis.
  • Expanded data support: nested JSON writes and additional complex, binary, and temporal types.
  • Redis Software Flex support, within the documented capability restrictions.
  • Better diagnostics: EXPLAIN information showing pushdown policy and applied operations.

Pushdown depends on whether Redis can preserve the query’s SQL semantics. Operations that need Trino execution stay there, including joins and window functions.

This version requires Trino 484 and Java 25. The release includes the plugin ZIP and a PDF user guide.

Code and getting started · Release notes and downloads