Yu Xu created CALCITE-6906:
------------------------------
Summary: 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
Fix For: 1.40.0
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)
