[
https://issues.apache.org/jira/browse/CALCITE-6771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17911254#comment-17911254
]
xiaochen.zhou edited comment on CALCITE-6771 at 1/8/25 10:45 PM:
-----------------------------------------------------------------
OK. Thank you for your reminder.[~mbudiu] I have updated the Jira, changing
"Convert Type from FLOAT to REAL in PrestoDialect" to "Convert Type from FLOAT
to DOUBLE in PrestoDialect".
was (Author: JIRAUSER307021):
OK. Thank you for your reminder.[~mbudiu]
> Convert Type from FLOAT to DOUDLE in PrestoDialect
> ---------------------------------------------------
>
> Key: CALCITE-6771
> URL: https://issues.apache.org/jira/browse/CALCITE-6771
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: xiaochen.zhou
> Priority: Major
> Labels: pull-request-available
> Attachments: image-2025-01-09-06-24-40-939.png
>
>
> Since FLOAT type is not supported in Presto
> According to the documentation:
> [https://prestodb.io/docs/current/language/types.html#real]
> !image-2025-01-09-06-24-40-939.png|width=307,height=209!
> Using {{CAST(xxxx AS FLOAT)}} will result in an error:
> ```
> SELECT CAST(message_count AS FLOAT)
> FROM applydata_bigdata.kafka_topic_cluster_user_dept_month_one_day_msg_info
> {{WHERE ymd = 20250105}}
> {{```}}
> !https://note3.oss-cn-hangzhou.aliyuncs.com/source/image-20250109061448068.png!
> It should be converted to the DOUBLE type instead.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
