[BUG] JSQLParser Version : 4.9 RDBMS : not support clickhouse quantile expression

[Knight-ZXW]

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

[manticore-projects]

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]

we define a new function in our system that names like quantile_param(0.95, xx ...) then transform to quantile(0.95)(cost)