LodeHQ
AI news for people who shipFree, by email

Data · Thursday, 2 July 2026 · Issue 33 · 14 stories

OpenSearch slashes log costs 70% as Hudi indexes live

Data Engineering

OpenSearch’s new log engine cuts cost 70% and doubles speed

AWS launched a purpose-built log-analytics engine for Amazon OpenSearch Service that delivers up to 4× price-performance, 2× faster ingestion, and up to 70 % lower storage costs. It stores logs in columnar Parquet, routes queries to DataFusion or Lucene mid-query, and works with existing APIs, letting teams cut spend while keeping full search capabilities.

aws.amazon.com ↗8 min read at source

How Arcesium Halved Query Costs with DuckDB

Arcesium cut query costs and runtimes by about half by migrating thousands of Athena and Trino SQL jobs to DuckDB over 18 months. The lightweight OLAP engine handled S3‑backed Parquet data with 50% faster execution and 50% lower resource usage, unlocking scale for client onboarding. Their experience highlights practical steps and pitfalls for similar migrations.

medium.com ↗10 min read at source

ML & AI for Data

Meta’s DEmate boosts data‑engineering with recipe‑driven LLM assistant

Meta released DEmate, an LLM‑driven assistant that writes, reviews, and tests SQL pipelines inside its private analytics stack. By wrapping the model in a ‘Recipe Architecture’ that maps prompts to 70 custom data‑engineering recipes, the tool achieved an 80% acceptance rate and 3,500 weekly active users, showing how tuned LLMs can scale internal data workflows.

medium.com ↗8 min read at source

LLMs Spot Spark SQL Bottlenecks, Cutting Debug Time

Expedia’s team fed Spark SQL physical plans to a large language model, which automatically flags anti‑patterns like missing broadcasts, data skew, and excessive shuffles. The LLM then suggests concrete fixes, turning hours‑long manual triage into a few minutes and lowering cluster costs.

medium.com ↗9 min read at source

t0-alpha Shows Small Transformer Can Match Large Time‑Series Forecasting Benchmarks

t0-alpha, a 102M-parameter decoder-style transformer, demonstrates how modern time-series foundation models tokenise, attend causally, and output probabilistic quantiles. Running it reproduces the paper's CRPS 0.4941 and MASE 0.7240, showing competitive accuracy while remaining hardware‑friendly. Its patch‑based design points to calibration and routing as the next big leaps.

towardsdatascience.com ↗10 min read at source

Databases & Storage

Practice & Datasets

ScarfBench Shows AI Agents Falter on Enterprise Java Migration

IBM Research’s new ScarfBench benchmark tests AI coding agents on moving Java apps between Spring, Jakarta EE and Quarkus. Early results show agents can compile code but frequently fail to deploy or preserve behavior, especially for whole‑application migrations. The suite gives a realistic bar for AI‑driven modernization tools.

huggingface.co ↗4 min read at source

You’re caught up.

That was all 14 stories in the 2 July issue.