[
https://issues.apache.org/jira/browse/HIVE-27885?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17789609#comment-17789609
]
Naresh P R commented on HIVE-27885:
-----------------------------------
Thank you [~rameshkumar] & [~ngangam] for the review and commit.
> Cast decimal from string with space without digits before dot returns NULL
> --------------------------------------------------------------------------
>
> Key: HIVE-27885
> URL: https://issues.apache.org/jira/browse/HIVE-27885
> Project: Hive
> Issue Type: Bug
> Reporter: Naresh P R
> Assignee: Naresh P R
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
>
> eg.,
> select cast(".0000 " as decimal(8,4))
> {code:java}
> – Expected output
> 0.0000
> – Actual output
> NULL
> {code}
> select cast("0.0000 " as decimal(8,4))
> {code:java}
> – Actual output
> 0.0000
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
