[
https://issues.apache.org/jira/browse/HIVE-24598?focusedWorklogId=775032&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-775032
]
ASF GitHub Bot logged work on HIVE-24598:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 26/May/22 12:50
Start Date: 26/May/22 12:50
Worklog Time Spent: 10m
Work Description: kasakrisz merged PR #3322:
URL: https://github.com/apache/hive/pull/3322
Issue Time Tracking
-------------------
Worklog Id: (was: 775032)
Time Spent: 20m (was: 10m)
> Trim function should return null if any of its parameter is null
> ----------------------------------------------------------------
>
> Key: HIVE-24598
> URL: https://issues.apache.org/jira/browse/HIVE-24598
> Project: Hive
> Issue Type: Improvement
> Reporter: Krisztian Kasa
> Priority: Minor
> Labels: newbie, pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Hive throws exception when null is passed as a parameter of trim/rtrim/ltrim
> {code}
> select trim(null);
> {code}
> {code}
> org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:7 Wrong arguments
> 'TOK_NULL': trim takes only STRING/CHAR/VARCHAR types. Found VOID
> {code}
> However null should be returned. From SQL11 standard:
> a) Let S be the value of the <trim source>.
> b) If <trim character> is specified, then let SC be the value of <trim
> character>; otherwise, let SC be
> <space>.
> c) If at least one of S and SC is the null value, then the result of the
> <trim function> is the null value.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
