[
https://issues.apache.org/jira/browse/CALCITE-6926?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17939958#comment-17939958
]
Yu Xu commented on CALCITE-6926:
--------------------------------
[~mbudiu] Thanks for the infomation! but IMO if user want to convert from the
Calcite dialect to the clickhouse dialect with correct result, seems we could
not only follow Calcite type ，could you agree about my point?
> ClickHouse Float type should not be converted to Double type
> ------------------------------------------------------------
>
> Key: CALCITE-6926
> URL: https://issues.apache.org/jira/browse/CALCITE-6926
> 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
>
>
> In ClickHouse float should to be Float32, double to be Float64, this can
> refer to document:
> [https://clickhouse.com/docs/sql-reference/data-types/float]
>
> The equivalent types in ClickHouse and in C are given below:
> * {{Float32}} — {{{}float{}}}.
> * {{Float64}} — {{{}double{}}}.
>
> Float types in ClickHouse have the following aliases:
> * {{Float32}} — {{{}FLOAT{}}}, {{{}REAL{}}}, {{{}SINGLE{}}}.
> * {{Float64}} — {{{}DOUBLE{}}}, {{{}DOUBLE PRECISION{}}}.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
