[ https://issues.apache.org/jira/browse/CALCITE-6909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-6909: ------------------------------------ Labels: pull-request-available (was: ) > Support ClickHouse Dailect with Decimal type > -------------------------------------------- > > Key: CALCITE-6909 > URL: https://issues.apache.org/jira/browse/CALCITE-6909 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: 1.39.0 > Reporter: Yu Xu > Assignee: Yu Xu > Priority: Major > Labels: pull-request-available > Fix For: 1.40.0 > > > Currently Calcite not support Decimal type in ClickHouse dialect. > In ClickHouse: > * P - precision. Valid range: [ 1 : 76 ]. > * S - scale. Valid range: [ 0 : P ]. > Depending on P parameter value Decimal(P, S) is a synonym for: > * P from [ 1 : 9 ] - for Decimal32(S) > * P from [ 10 : 18 ] - for Decimal64(S) > * P from [ 19 : 38 ] - for Decimal128(S) > * P from [ 39 : 76 ] - for Decimal256(S) > > we can refer to doc with: > https://clickhouse.com/docs/sql-reference/data-types/decimal -- This message was sent by Atlassian Jira (v8.20.10#820010)