REVIEW 3 major objections 7 minor 38 references
Natural-language log querying works only after raw logs are turned into parser-induced, semantically grounded relational schemas so an LLM can emit correct SQL.
Reviewed by Pith at T0; open to challenge. T0 means a machine referee read the full paper against a public rubric. the ladder, T0–T4 →
T0 review · grok-4.5
2026-07-11 23:15 UTC pith:VI66C7VK
load-bearing objection Solid systems paper: schema induction + grounding is the real lever for NL log analytics, with a large execution-verified bench and clean ablations; the main soft spot is LLM-built gold that may favor SQL-shaped intents. the 3 major comments →
LogNLQ: Natural-Language Log Querying with Parser-Induced and Semantically Grounded Schemas
The pith
A machine-rendered reading of the paper's core claim, the machinery that carries it, and where it could break.
Core claim
Parser-induced relational structuring is an absolute prerequisite for executable natural-language log analytics. Once that structure exists, dual-granularity semantic grounding of templates and parameter columns lets an LLM map user intent onto the correct physical fields and generate executable SQL that substantially outperforms text-based QA, Log-DSL generation, and schema-free Text-to-SQL on both retrieval and aggregation, especially for multi-event diagnostic scenarios.
What carries the argument
The schema document: a per-template package holding the event id, template string, natural-language event summary, and for each parameter column its physical name, canonical semantic name, description, and statistical profile. Dual-granularity grounding (template summaries plus vocabulary-anchored parameter labels) makes these documents the retrieval units and the only legal context for constrained SQL generation.
Load-bearing premise
The benchmark questions, largely written by an LLM from sampled log windows and only lightly hand-checked, faithfully represent real operator intent and do not favor systems that reason like the question generator.
What would settle it
An independent set of human SRE queries written without access to the induced schemas yields LogNLQ retrieval F1 and aggregation match rates that fall to the level of the schema-free baselines.
If this is right
- Without first inducing relational structure from log templates, corpus-level aggregation and parameter-role filtering stay unreliable.
- Semantic labels on positional columns are required for an LLM to map phrases like “source IP” onto the right physical field.
- Constraining SQL generation to a small retrieved set of grounded schema documents sharply reduces field hallucination.
- Template-partitioned columnar storage can shrink footprint relative to raw logs while still supporting analytical execution.
- Cross-template diagnostic queries become tractable once a shared parameter vocabulary aligns columns for UNION or JOIN.
Where Pith is reading between the lines
- The same induce-then-ground pattern could be applied to other semi-structured operational data such as traces or metrics that lack stable human-authored schemas.
- Because end-to-end latency is dominated by LLM SQL generation, faster or cheaper generators would improve interactive use without changing the schema layer.
- Human-authored industrial query logs would be a stronger external test of whether the large measured gains transfer beyond LLM-written benchmarks.
- A stable global parameter vocabulary may eventually support multi-system log federation if services can be grounded into shared role names.
Editorial analysis
A structured set of objections, weighed in public.
Referee Report
Summary. LogNLQ reformulates natural-language log querying as executable SQL generation over schemas that are first induced from raw logs by parsing and then annotated by dual-granularity semantic grounding (template summaries plus parameter names/descriptions, with a global parameter vocabulary for cross-template consistency). Offline, logs are materialized as template-partitioned columnar tables with statistical profiles; online, FAISS retrieves Top-K schema documents and an LLM generates schema-constrained SQL executed by DuckDB. The authors introduce LogNLQ-Bench (8,895 execution-verified retrieval and aggregation queries on OpenSSH, HDFS, Spark, and BGL, basic and scenario) and report large gains over text QA, Log-DSL, and schema-free Text-to-SQL baselines (Table 2), with ablations arguing that parser-induced structure is an absolute prerequisite and semantic grounding the next major contributor (Figure 8).
Significance. The paper addresses a real gap in observability tooling: raw logs lack an executable schema, so conventional Text-to-SQL and DSL generation fail for parameter-role filtering and corpus-level aggregation. Framing log parsing as execution-oriented schema induction, plus dual-granularity grounding and constrained SQL, is a clear and useful systems contribution. Strengths include an execution-verified (not surface-form) evaluation, a large multi-dataset benchmark, hierarchical ablations, Top-K and multi-backbone sensitivity, and practical storage/latency measurements showing compression relative to raw logs and index backends. If the central claim holds under stronger human validation of the benchmark, the work would be a solid reference for NL interfaces over semi-structured operational data.
major comments (3)
- Section 4.1 / construct validity of LogNLQ-Bench: Questions and gold answers are produced by an LLM that, from a sampled raw-log window, jointly invents a diagnostic question and an executable analysis program; only instances with successful non-empty program execution are kept, and only ~2% (200) instances are manually inspected, with no reported human-SRE agreement or ticket-distribution comparison. This selection can systematically retain intents that already admit structured programmatic solutions and under-represent local span/label queries that text QA or Log-DSL handle well. The strong claim that parser-induced structuring is an “absolute prerequisite” (RQ1/RQ3, Table 2, Figure 8) therefore partly rests on a generator that may share inductive biases with the SQL agent. Please add a human-authored or human-rewritten control subset (or inter-annotator study with SREs), report failur
- Section 5.3 / Figure 8 ablation design: The “w/o parsing-based structuring” variant is equated with the DIN-SQL baseline over monolithic Content storage rather than ablating structure inside the LogNLQ pipeline (same retrieval/generation stack, only without template partitions and parameter columns). DIN-SQL differs in decomposition, prompting, and schema linking, so the collapse of Aggregation RO-Match to ~0.03 confounds “no structure” with “different system.” A true ablation—e.g., LogNLQ-style generation over a single raw-text table, or over parser tables without semantic index—would isolate the structural claim. Please replace or supplement this variant and restate the hierarchical-dependency conclusion accordingly.
- Section 4.2 baseline fairness and Section 5.1 error analysis: Baselines are evaluated under native schema-light assumptions (by design), but the paper does not report whether giving Elasticsearch/Loki/LogQLLM access to the same parser-extracted fields (even without full dual-granularity grounding) would close much of the gap. Without that control, Table 2’s wide margins support “structure helps” more cleanly than “only LogNLQ’s full stack works.” A minimal structured-field baseline (or LogQL/ES over induced columns) would make the contribution of semantic grounding vs. mere field exposure clearer and strengthen the comparison.
minor comments (7)
- Front matter still uses ACM placeholder metadata (Conference acronym ’XX, Woodstock, NY, 2018 copyright year). Replace with the target venue’s correct title, year, and rights block.
- Section 4.4 cites “LILAC [?]” with an unresolved reference; complete the bibliography entry and ensure all LogHub/parser citations are consistent with Section 6.
- Figure 1 panel labels in the text (Text-based QA / Log-DSL / Text-to-SQL) appear swapped relative to the failure modes described in the surrounding paragraphs; align figure callouts with the narrative.
- Definition 1 and Section 3.3: clarify whether statistical profiles σ_i are ever used in retrieval embeddings or only at generation time (text says not indexed; ensure the prompt template in the artifact matches).
- Table 2: report Precision/Recall alongside F1 for retrieval, and confidence intervals or per-scenario-type breakdowns for the 1,139 scenario queries (Alert/Triage/Mitigation/RCA/Audit/Report) claimed to be nearly uniform.
- Section 5.4 acknowledges multi-table join quality as future work; a short quantitative note on how often generated SQL uses UNION/JOIN and its RO-Match would help readers gauge current limits.
- Data Availability points to a Zenodo DOI; ensure the camera-ready includes scripts to regenerate Table 2/Figures 8–10 from the released bench for reproducibility.
Circularity Check
No definitional or fitted circularity in the method or claims; only minor non-load-bearing self-use of the authors' prior LILAC parsing infrastructure as an implementation substrate.
specific steps
-
self citation load bearing
[Section 4.4 Implementation Details]
"The offline pipeline is implemented using a custom schema induction component whose streaming template extraction builds on the cache-tree dispatch mechanism of LILAC [?], extended to support execution-oriented relational structuring."
LILAC is prior work by overlapping authors; the paper uses it as the substrate for the central schema-induction step. This is ordinary self-use of infrastructure rather than a load-bearing uniqueness or derivation claim, so it raises the score only to the minor level (2) and does not force any empirical result.
full rationale
LogNLQ's core chain (parse raw logs into template-partitioned tables, dual-granularity grounding into schema documents, retrieve, constrain LLM SQL, execute, score by F1/RO-Match against independent execution outputs) does not reduce any claimed result to its inputs by construction. The absolute-prerequisite claim for parser-induced structure is an empirical ablation result (Fig. 8 / RQ3) against DIN-SQL and other baselines on LogNLQ-Bench, not a tautology. Benchmark construction (Sec. 4.1) uses an LLM to propose questions and raw-log analysis programs, retaining only successfully executing non-empty cases, then evaluates systems by match to those outputs; this is a validity/selection concern (acknowledged in threats) but not circular derivation, because ground-truth programs operate over raw logs independently of the induced schema and LogNLQ must still produce matching results via SQL. Self-citations to the authors' parsing line (LILAC and related) supply infrastructure only; they are not invoked as uniqueness theorems that force the central claims. No fitted parameters are renamed predictions, no ansatz is smuggled, and no known result is merely renamed. Score 2 reflects only the ordinary, non-load-bearing self-citation of prior tooling.
Axiom & Free-Parameter Ledger
free parameters (3)
- Top-K schema candidates =
5 (default)
- LLM backbone and temperature =
doubao-seed-2.0-pro, T=0.0
- Statistical profile top-K frequent values and sampling for grounding
axioms (4)
- domain assumption Raw logs are produced by logging statements and therefore admit recurring templates with typed dynamic parameters that can be mapped to relational tables.
- domain assumption Executable SQL over induced partitions is an adequate and preferable target for analytical NL log queries versus span QA or backend DSLs.
- ad hoc to paper LLM-based dual-granularity grounding plus a global parameter vocabulary yields sufficiently consistent semantic names for retrieval and cross-template SQL.
- ad hoc to paper Nearest-neighbor retrieval over FAISS-encoded schema documents surfaces the templates needed for correct SQL within small Top-K.
invented entities (3)
-
Schema Document D_k
no independent evidence
-
Global parameter vocabulary G with vocabulary-anchored grounding
no independent evidence
-
LogNLQ-Bench (8,895 execution-verified NL queries)
no independent evidence
read the original abstract
Logs are essential for system monitoring and failure diagnoses in modern software systems, yet querying them through natural language remains an open challenge. Existing approaches either treat logs as plain text, generate queries for schema-light backends, or assume predefined relational schemas, but none addresses a fundamental obstacle: raw logs carry no executable schema over which structured queries can be defined and run. To address these limitations, we present LogNLQ, a framework that formulates natural-language log querying as executable SQL generation over parser-induced and semantically grounded schemas. LogNLQ parses raw logs into template-partitioned relational tables, then applies dual-granularity semantic grounding to annotate both templates and parameter columns with interpretable names and descriptions. At query time, relevant schema candidates are retrieved via semantic search, and a large language model (LLM) generates executable SQL constrained to the retrieved context. To support rigorous evaluation, we introduce LogNLQ-Bench, an execution-verified benchmark of 8,895 queries over four real-world log datasets. Experimental results demonstrate that LogNLQ consistently outperforms all representative baselines by wide margins, with especially pronounced gains on analytically complex scenario queries.
Figures
Reference graph
Works this paper leans on
-
[1]
2016.Site Reliability Engineering: How Google Runs Production Systems(1st ed.)
Betsy Beyer, Chris Jones, Jennifer Petoff, and Niall Richard Murphy. 2016.Site Reliability Engineering: How Google Runs Production Systems(1st ed.). O’Reilly Media, Inc. Available at https://sre.google/sre-book/
2016
-
[2]
Zhuangbin Chen, Jinyang Liu, Wenwei Gu, Yuxin Su, and Michael R Lyu. 2021. Ex- perience report: Deep learning-based system log analysis for anomaly detection. arXiv preprint arXiv:2107.05908(2021)
Pith/arXiv arXiv 2021
-
[3]
Min Du, Feifei Li, Guineng Zheng, and Vivek Srikumar. 2017. Deeplog: Anomaly detection and diagnosis from system logs through deep learning. InProceedings of the 2017 ACM SIGSAC conference on computer and communications security. 1285–1298
2017
-
[4]
Elastic. 2026. Elasticsearch: The Heart of the Free and Open Elastic Stack. https: //www.elastic.co/elasticsearch/. Accessed: 2026-03-27
2026
-
[5]
2023.LogQL: Log Query Language
Grafana Labs. 2023.LogQL: Log Query Language. https://grafana.com/docs/loki/ latest/logql/ Accessed: 2026-03-20
2023
-
[6]
Grafana Labs. 2026. Loki: Like Prometheus, but for logs. https://grafana.com/ oss/loki/. Accessed: 2026-03-27
2026
-
[7]
Pinjia He, Zhuangbin Chen, Shilin He, and Michael R. Lyu. 2018. Characterizing the natural language descriptions in software logging statements. InProceedings of the 33rd ACM/IEEE International Conference on Automated Software Engineering, ASE 2018, Montpellier, France, September 3-7, 2018, Marianne Huchard, Christian Kästner, and Gordon Fraser (Eds.). AC...
-
[8]
Pinjia He, Jieming Zhu, Zibin Zheng, and Michael R Lyu. 2017. Drain: An online log parsing approach with fixed depth tree. In2017 IEEE international conference on web services (ICWS). IEEE, 33–40
2017
-
[9]
Shilin He, Pinjia He, Zhuangbin Chen, Tianyi Yang, Yuxin Su, and Michael R. Lyu. 2022. A Survey on Automated Log Analysis for Reliability Engineering. ACM Comput. Surv.54, 6 (2022), 130:1–130:37. doi:10.1145/3460345
doi:10.1145/3460345 2022
-
[10]
Shilin He, Xu Zhang, Pinjia He, Yong Xu, Liqun Li, Yu Kang, Minghua Ma, Yining Wei, Yingnong Dang, Saravanakumar Rajmohan, et al. 2022. An empirical study of log analysis at Microsoft. InProceedings of the 30th ACM Joint European Software Engineering Conference and Symposium on the Foundations of Software Engineering. 1465–1476
2022
-
[11]
Shilin He, Jieming Zhu, Pinjia He, and Michael R Lyu. 2016. Experience re- port: System log analysis for anomaly detection. In2016 IEEE 27th international symposium on software reliability engineering (ISSRE). IEEE, 207–218
2016
-
[12]
Junjie Huang, Zhihan Jiang, Zhuangbin Chen, and Michael R. Lyu. 2025. No More Labelled Examples? An Unsupervised Log Parser with LLMs.Proc. ACM Softw. Eng.2, FSE (2025), 2406–2429. doi:10.1145/3729377
doi:10.1145/3729377 2025
-
[13]
Shaohan Huang, Yi Liu, Carol Fung, Jiaxing Qi, Hailong Yang, and Zhongzhi Luan. 2023. Logqa: Question answering in unstructured logs.arXiv preprint arXiv:2303.11715(2023)
Pith/arXiv arXiv 2023
-
[14]
Ziwei Ji, Nayeon Lee, Rita Frieske, Tiezheng Yu, Dan Su, Yan Xu, Etsuko Ishii, Yejin Bang, Andrea Madotto, and Pascale Fung. 2023. Survey of Hallucination in Natural Language Generation.ACM Comput. Surv.55, 12 (2023), 248:1–248:38. doi:10.1145/3571730
doi:10.1145/3571730 2023
-
[15]
Zhihan Jiang, Jinyang Liu, Zhuangbin Chen, Yichen Li, Junjie Huang, Yintong Huo, Pinjia He, Jiazhen Gu, and Michael R Lyu. 2024. Lilac: Log parsing using llms with adaptive parsing cache.Proceedings of the ACM on Software Engineering 1, FSE (2024), 137–160
2024
-
[16]
Zhihan Jiang, Jinyang Liu, Junjie Huang, Yichen Li, Yintong Huo, Jiazhen Gu, Zhuangbin Chen, Jieming Zhu, and Michael R Lyu. 2024. A large-scale evaluation for log parsing techniques: How far are we?. InProceedings of the 33rd ACM SIGSOFT International Symposium on Software Testing and Analysis. 223–234
2024
-
[17]
Yichen Li, Jinyang Liu, Junsong Pu, Zhihan Jiang, Zhuangbin Chen, Xiao He, Tieying Zhang, Jianjun Chen, Yi Li, Rui Shi, and Michael R. Lyu. 2025. Automated Proactive Logging Quality Improvement for Large-Scale Codebases. In40th IEEE/ACM International Conference on Automated Software Engineering, ASE 2025, Seoul, Korea, Republic of, November 16-20, 2025. I...
arXiv 2025
-
[18]
Yilun Liu, Shimin Tao, Weibin Meng, Feiyu Yao, Xiaofeng Zhao, and Hao Yang
-
[19]
LogPrompt: Prompt Engineering Towards Zero-Shot and Interpretable Log Analysis. InProceedings of the 2024 IEEE/ACM 46th International Conference on Software Engineering: Companion Proceedings, ICSE Companion 2024, Lisbon, Portugal, April 14-20, 2024. ACM, 364–365. doi:10.1145/3639478.3643108
-
[20]
Zeyang Ma, Dong Jae Kim, and Tse-Hsun Peter Chen. 2025. LibreLog: Accurate and Efficient Unsupervised Log Parsing Using Open-Source Large Language Models. In47th IEEE/ACM International Conference on Software Engineering, ICSE 2025, Ottawa, ON, Canada, April 26 - May 6, 2025. IEEE, 924–936. doi:10.1109/ ICSE55347.2025.00103
arXiv 2025
-
[21]
Microsoft. 2023. Kusto Query Language (KQL) Overview. https://learn.microsoft. com/en-us/azure/data-explorer/kusto/query/. Accessed: 2026-03-20
2023
-
[22]
Oliner, Archana Ganapathi, and Wei Xu
Adam J. Oliner, Archana Ganapathi, and Wei Xu. 2012. Advances and challenges in log analysis.Commun. ACM55, 2 (2012), 55–61. doi:10.1145/2076450.2076466
-
[23]
Mohammadreza Pourreza and Davood Rafiei. 2023. Din-sql: Decomposed in- context learning of text-to-sql with self-correction.Advances in neural information processing systems36 (2023), 36339–36348
2023
-
[24]
Jiaxing Qi, Zhongzhi Luan, Shaohan Huang, Carol Fung, and Hailong Yang. 2024. LogSay: An Efficient Comprehension System for Log Numerical Reasoning.IEEE Trans. Comput.73, 7 (2024), 1809–1821
2024
-
[25]
Vishwanath Seshagiri, Siddharth Balyan, Vaastav Anand, Kaustubh Dhole, Ishan Sharma, Avani Wildani, José Cambronero, and Andreas Züfle. 2024. Chatting with logs: An exploratory study on finetuning llms for logql.arXiv preprint arXiv:2412.03612(2024)
Pith/arXiv arXiv 2024
-
[26]
Shiwen Shan, Yintong Huo, Yuxin Su, Yichen Li, Dan Li, and Zibin Zheng. 2024. Face It Yourselves: An LLM-Based Two-Stage Strategy to Localize Configuration Errors via Logs. InProceedings of the 33rd ACM SIGSOFT International Symposium on Software Testing and Analysis, ISSTA 2024, Vienna, Austria, September 16-20, 2024, Maria Christakis and Michael Pradel ...
arXiv 2024
-
[27]
Shiwen Shan, Yintong Huo, Hongzhan Zhong, Zhining Wang, Yuxin Su, and Zibin Zheng. 2026. LogFold: Compressing Logs with Structured Tokens and Hybrid Encoding.arXiv preprint arXiv:2603.20618(2026)
arXiv 2026
-
[28]
Xinye Tang, Amir H Abdi, Jeremias Eichelbaum, Mahan Das, Alex Klein, Ni- hal Irmak Pakis, William Blum, Daniel L Mace, Tanvi Raja, Namrata Padmanab- han, et al. 2024. Nl2kql: From natural language to kusto query.arXiv preprint arXiv:2404.02933(2024)
Pith/arXiv arXiv 2024
-
[29]
Jiabo Wang, Guojun Chu, Jingyu Wang, Haifeng Sun, Qi Qi, Yuanyi Wang, Ji Qi, and Jianxin Liao. 2024. LogExpert: Log-based Recommended Resolutions Generation using Large Language Model. InProceedings of the 2024 ACM/IEEE 44th International Conference on Software Engineering: New Ideas and Emerging Results, NIER@ICSE 2024, Lisbon, Portugal, April 14-20, 202...
arXiv 2024
-
[30]
Yilun Wang, Pengfei Chen, Haiyu Huang, Zilong He, Gou Tan, Chuanfu Zhang, Jingkai He, and Zibin Zheng. 2025. InferLog: Accelerating LLM Inference for Online Log Parsing via ICL-oriented Prefix Caching.CoRRabs/2507.08523 (2025). arXiv:2507.08523 doi:10.48550/ARXIV.2507.08523
-
[31]
Yidan Wang, Zhouruixing Zhu, Qiuai Fu, Yuchi Ma, and Pinjia He. 2024. MRCA: Metric-level Root Cause Analysis for Microservices via Multi-Modal Data. In Proceedings of the 39th IEEE/ACM International Conference on Automated Software Engineering, ASE 2024, Sacramento, CA, USA, October 27 - November 1, 2024, Vladimir Filkov, Baishakhi Ray, and Minghui Zhou (...
-
[32]
Pei Xiao, Chiming Duan, Minghua He, Tong Jia, Yifan Wu, Jing Xu, Gege Gao, Lingzhe Zhang, Weijie Hong, Ying Li, and Gang Huang. 2025. CoorLog: Efficient- Generalizable Log Anomaly Detection via Adaptive Coordinator in Software Evolution. In40th IEEE/ACM International Conference on Automated Software Engineering, ASE 2025, Seoul, Korea, Republic of, Novemb...
-
[33]
Yongzheng Xie, Hongyu Zhang, and Muhammad Ali Babar. 2024. LogSD: De- tecting Anomalies from System Logs through Self-Supervised Learning and Frequency-Based Masking.Proc. ACM Softw. Eng.1, FSE (2024), 2098–2120. doi:10.1145/3660800
-
[34]
Junjielong Xu, Ruichun Yang, Yintong Huo, Chengyu Zhang, and Pinjia He. 2024. DivLog: Log Parsing with Prompt Enhanced In-Context Learning. InProceedings of the 46th IEEE/ACM International Conference on Software Engineering, ICSE 2024, Lisbon, Portugal, April 14-20, 2024. ACM, 199:1–199:12. doi:10.1145/3597503. 3639155
doi:10.1145/3597503 2024
-
[35]
Siyu Yu, Yifan Wu, Ying Li, and Pinjia He. 2024. Unlocking the Power of Num- bers: Log Compression via Numeric Token Parsing. InProceedings of the 39th IEEE/ACM International Conference on Automated Software Engineering, ASE 2024, Sacramento, CA, USA, October 27 - November 1, 2024, Vladimir Filkov, Baishakhi Ray, and Minghui Zhou (Eds.). ACM, 919–930. doi...
-
[36]
Tao Yu, Rui Zhang, Kai Yang, Michihiro Yasunaga, Dongxu Wang, Zifan Li, James Ma, Irene Li, Qingning Yao, Shanelle Roman, et al. 2018. Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text- to-sql task. InProceedings of the 2018 conference on empirical methods in natural language processing. 3911–3921
2018
-
[37]
Ding Yuan, Soyeon Park, and Yuanyuan Zhou. 2012. Characterizing logging practices in open-source software. In34th International Conference on Software Engineering, ICSE 2012, June 2-9, 2012, Zurich, Switzerland, Martin Glinz, Gail C. Murphy, and Mauro Pezzè (Eds.). IEEE Computer Society, 102–112. doi:10.1109/ ICSE.2012.6227202
arXiv 2012
-
[38]
Chenbo Zhang, Wenying Xu, Jinbu Liu, Lu Zhang, Guiyang Liu, Jihong Guan, Qi Zhou, and Shuigeng Zhou. 2025. LogBase: A Large-Scale Benchmark for Semantic Log Parsing.Proc. ACM Softw. Eng.2, ISSTA (2025), 2091–2112. doi:10. 1145/3728969
2025
discussion (0)
Sign in with ORCID, Apple, or X to comment. Anyone can read and Pith papers without signing in.