You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ossie.apache.org by "MahmoudHassanen99 (via GitHub)" <gi...@apache.org> on 2026/10/09 12:49:20 UTC
[I] [Feature][converters] Add native ClickHouse SQL dialect converter [ossie]
MahmoudHassanen99 opened a new issue, #546:
URL: https://github.com/apache/ossie/issues/546
### Motivation
Currently, Ossie provides converters for engines like dbt, GoodData, and Databricks, but lacks a dedicated dialect compiler for ClickHouse.
ClickHouse has distinct function semantics that cause standard ANSI SQL generators to fail or perform sub-optimally:
- Distinct metrics require specialized combinators (`uniqExact`, `uniqCombined64`).
- Percentiles/quantiles require parametric aggregate syntax (`quantileExact(level)(col)`).
- Temporal grains rely on native bucketing (`toStartOfDay`, `toStartOfMonth`, etc.).
### Proposed Implementation
- Add ClickHouse dialect conversion module under `converters/clickhouse/`.
- Implement standard metric mappings for basic aggregates, quantiles, and time grains.
- Implement zero-division safety using `nullIf(divisor, 0)`.
- Add unit and snapshot tests with `pytest`.
### Assignment
I would like to implement this. Please assign the issue to me.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@ossie.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org