You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2021/01/07 09:33:00 UTC
[jira] [Created] (HIVE-24598) Trim function should return null if
any of its parameter is null
Krisztian Kasa created HIVE-24598:
-------------------------------------
Summary: 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
Hive throws exception when null is passed as a parameter of trim/rtrim/ltrim
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.3.4#803005)