[
https://issues.apache.org/jira/browse/CALCITE-6906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alessandro Solimando updated CALCITE-6906:
------------------------------------------
Fix Version/s: (was: 1.40.0)
> Support ClickHouse Dialect with cube with syntax
> ------------------------------------------------
>
> Key: CALCITE-6906
> URL: https://issues.apache.org/jira/browse/CALCITE-6906
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.39.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Major
> Labels: pull-request-available
>
> Currently ClickHouse dialect not support group by ... with cube syntax，but in
> ClickHouse it support it which can refer
> to：[https://clickhouse.com/docs/sql-reference/statements/select/group-by]
> at the same time I had test the syntax from earlier version 18.0 ~ latest all
> support the syntax,
> eg:
> select * from (select 1 as a,2 as b,3 as c from system.numbers limit 1) a
> group by a,b,c with CUBE;
> result:
> 1 2 3
> 1 2 0
> 1 0 3
> 1 0 0
> 0 2 3
> 0 2 0
> 0 0 3
> 0 0 0
>
> so we need to support it in Caclite.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
