search

ClickHouse / clickhouse-tableau-connector-jdbc

Tableau connector to ClickHouse using JDBC driver
Apache License 2.0
57 stars 9 forks source link

Feature request: add sumIf, countIf, etc. formulas #32

Closed kuntzi closed 2 years ago

kuntzi commented 2 years ago

This is not an issue, just new feature request.

Could you please add sumIf (SUM_IF), countIf (COUNT_IF) uniqIf (COUNTD_IF), etc. formulas to your connector? Performance of native functions in ClickHouse is much better then nested formulas like SUM(CASW WHEN ...) and develoment in Tableau will be much easier.

Thanks

yurifal commented 2 years ago

Hi @kuntzi and thank you for the feature request.

While waiting for the Aggregate Combinators to be implemented (written in the dialect.tdd of the Connector), you may want to write them "as is" using the RAWSQLAGG functionality (Live Connection only, no extract).

kuntzi commented 2 years ago

@yurifal Thanks for excelent idea, I just forgot about this function.

yurifal commented 2 years ago

Closed with this commit.