arXiv Science⌕ Search

arXiv subjects

Erick Lee

Publications and source records attributed to Erick Lee.

3 recordsLinked to original sources

FlinkEval: A Synthetic Corpus for Evaluating Natural Language Interfaces to Streaming SQL

Existing natural-language-to-SQL benchmarks primarily evaluate queries over bounded relational data, leaving streaming semantics underexplored. We introduce FlinkEval, an execution-grounded synthetic benchmark comprising 3,903 question--SQL pairs across 45 industry domains and 45 semantic labels. We create diverse schemas and domain-plausible, temporally consistent data through iterative generation and validation. SQL patterns collected from the human-written NL2SQL pairs and vendor documentation drive quota-balanced generation, and execution with a repair loop on Confluent Cloud Apache Flink produces reference queries covering windowing, temporal joins, pattern matching, nested types, and data manipulation. The corpus includes paired schema-explicit and business-language requests, with annotations for analysis by query pattern, complexity, and execution mode. A seven-level Question Specification Ladder examines semantics-preserving reformulation and underspecified requests augmented with oracle-derived clues. Baseline evaluations combine execution outcomes with adjudicated LLM judgments, revealing challenges in pattern composition and request specification.

cs.DB↗

Self-Refining Prompt Induction for Streaming Text-to-SQL

Text-to-SQL assistants for streaming engines must handle dialect-specific types, windowing rules, and temporal semantics, including constructs poorly handled by generic prompts. We present Self-Refining Prompt Induction (SRPI), an offline method that converts generation failures into reusable dialect instructions while keeping model weights fixed. A Refiner revises the Generator's prompt using reference-conditioned feedback from three LLM judges; a sampled regression guard checks earlier successes, and a separate Compressor reduces prompt length. Inference uses the frozen prompt without retrieval or query repair. We evaluate cross-domain and cross-model transfer on Confluent Cloud Flink SQL using a controlled synthetic workload seeded by 30 expert-written examples, with 335 induction examples and 257 questions from held-out domains. The same induced prompt improves mean judge scores across seven Generators by 7.1-19.2 percentage points, including an increase from 85.3% to 97.5% for the induction model. A separate compression study reduces prompt length by 52.7% with a 0.19-percentage-point score decrease. An assistant using the induced prompt is in early access, with initial user feedback to inform subsequent refinement.

cs.CL↗

Nonlinear Single-Armed Spiral Density Waves in Nearly Keplerian Disks

Single-armed, stationary density waves can propagate in very weakly self-gravitating gas disks dominated by a central mass. Examples include circumstellar disks of protostars and molecular disks in galactic nuclei. We explore the linear and nonlinear dynamics of such waves. Variational methods yield nonlinear versions of the dispersion relation, angular momentum flux, and propagation velocity in the tight-winding limit. The pitch angle increases with amplitude until the tight-winding approximation breaks down. We also find a series of nonlinear logarithmic spirals which is exact in the limit of small disk mass and which extends to large pitch angle.

astro-ph↗