Yu Xu created CALCITE-6909:
------------------------------
Summary: 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
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)
