[jira] [Closed] (CALCITE-6906) Support ClickHouse Dialect with cube with syntax

["Alessandro Solimando (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-6906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alessandro Solimando closed CALCITE-6906.
-----------------------------------------

> 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)