Repository navigation
[BUG] JSQLParser Version : 4.9 RDBMS : not support clickhouse quantile expression #2125
Description
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
quantile(0.95)(cost) not support
SQL Example:
select toStartOfDay(timestamp) AS date, count(1) as count, quantile(0.95)(cost) as 95cost from apm_log_event
Software Information:
- JSqlParser 4.9
- Database :Clickhouse
Activity
manticore-projects commentedon Dec 18, 2024
Greetings.
This is unsupported syntax far away from any standard and you would need to provide or sponsor an implementation to make it happen.
Yizhe1208 commentedon Jun 6, 2025
we define a new function in our system
that names like quantile_param(0.95, xx ...) then transform to quantile(0.95)(cost)
fix: support ClickHouse parametric aggregate calls
fix: support ClickHouse parametric aggregate calls (#2393)