Same Query, Different Answer: Run-to-Run Variance in Semantic Query Processing
Not on the map. Why?
Abstract (arXiv)
Semantic query engines ask a large language model (LLM) to judge individual rows, and benchmarks compare these engines on the quality of a few executions at temperature 0. We measure how much another execution changes. We re-execute the text and tabular workloads of SemBench, LRO-Bench, and UDA-Bench through their own harnesses, log every one of 1.2 million model calls, and reanalyze SemBench's published executions. At temperature 0, between 0.07% and 10.2% of rows change their operator output over five executions, depending on the model, and up to 24.0% on one task. Plans amplify these changes exponentially in the number of rows an answer exposes, as a possible-worlds model predicts: on UDA-Bench, a few percent of extracted values change, but about two thirds of the answers do. In SemBench's published results, 21% of text results change quality between executions, including on engines whose plans are deterministic. Several per-query system comparisons, and 16 of 28 tests of LRO-Bench's implementation recommendations, are not settled by the executions the benchmarks run. Changing rows are rows on which models disagree with each other; identical requests within one execution disagree as often as across executions; and one execution's decision margin or reasoning length predicts which rows change. Voting reduces the variance but does not remove it, and a calibrated cascade keeps its guarantee while the rows it returns change. We derive reporting rules for benchmarks and design rules for engines.
Key facts. No citing papers in the map yet (data through 14 Oct 2026). Builds on 24 of its 57 references that are in the map. First posted on arXiv 9 Oct 2026.
Builds on
24 of 57 references.
References · 24
- 2022Language Models (Mostly) Know What They Knowcited by 1,856
- 2021Accounting for Variance in Machine Learning Benchmarkscited by 201
- 2024The Good, The Bad, and The Greedy: Evaluation of LLMs Should Not Ignore Non-Determinismcited by 116
- 2023Language Models Enable Simple Systems for Generating Structured Views of Heterogeneous Data Lakescited by 111
- 2024A Declarative System for Optimizing AI Workloadscited by 37
- 2024Optimizing LLM Queries in Relational Data Analytics Workloadscited by 22
- 2024UQE: A Query Engine for Unstructured Databasescited by 21
- 2020Approximate Selection with Guarantees using Proxiescited by 15
- 2025Beyond Quacking: Deep Integration of Language Models and RAG into DuckDBcited by 15
- 2025Abacus: A Cost-Based Optimizer for Semantic Operator Systemscited by 13
- 2025Cut Costs, Not Accuracy: LLM-Powered Data Processing with Guaranteescited by 9
- 2025Featurized-Decomposition Join: Low-Cost Semantic Joins with Guaranteescited by 5
12 more
- 2026Larch: Learned Query Optimization for Semantic Predicatescited by 4
- 2026Sema: A High-performance System for LLM-based Semantic Query Processingcited by 3
- 2025Unstructured Data Analysis using LLMs: A Comprehensive Benchmarkcited by 2
- 2026Large Language Model-Enhanced Relational Operators: Taxonomy, Benchmark, and Analysiscited by 2
- 2026Accelerating Approximate Analytical Join Queries over Unstructured Data with Statistical Guaranteescited by 2
- 2026PLOP: Cost-Based Placement of Semantic Operators in Hybrid Query Planscited by 2
- 2026Fast LLM-Based Semantic Filtering: From a Unified Framework to an Adaptive Two-Phase Methodcited by 2
- 2026CADENZA: Compiling Natural-Language Intent into Task-Specific Operator DAGs for Semantic Query Processingcited by 2
- 2026Kalypso: Relational LLM Servingcited by 2
- 2026From Interpretation to Compilation: A Compilation-Based Execution Engine for Semantic Operator Systemscited by 2
- 2026ListK: Semantic ORDER BY and LIMIT K with Listwise Promptingcited by 1
- 2026The Stochastic Shift: A New Evaluation Paradigm for Text-to-SQL with AI Operatorscited by 1
Built on by
Not cited yet.
Similar, not cited
Close in wording, no citation either way
- 2025SemBench: A Benchmark for Semantic Query Processing Engines
- 2026Same Question, Different Answers: Evaluating LLM Reliability Beyond Accuracy
- 2026Asynchronous Verified Semantic Caching for Tiered LLM Architectures
- 2024A Survey of Query Optimization in Large Language Models
- 2025Semantic Caching for Low-Cost LLM Serving: From Offline Learning to Online Adaptation
- 2026LLM NL2SQL Robustness: Surface Noise vs. Linguistic Variation in Traditional and Agentic Settings
- 2026How Small Can You Go? A Controlled Study of LoRA Rank, Target Modules, and Quantization Trade-offs for Text-to-SQL on a 60M-Parameter Model
- 2025BenchPress: A Human-in-the-Loop Annotation System for Rapid Text-to-SQL Benchmark Curation