You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by bo...@apache.org on 2019/08/29 12:44:08 UTC

[impala] 01/07: [DOCS] CONCAT function returns NULL if any argument is NULL

This is an automated email from the ASF dual-hosted git repository.

boroknagyz pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/impala.git

commit 20dec47ae6c377cf8281c32787b003e5e6f3c07a
Author: Alex Rodoni <ar...@cloudera.com>
AuthorDate: Wed Aug 28 10:51:56 2019 -0700

    [DOCS] CONCAT function returns NULL if any argument is NULL
    
    Change-Id: Ieadd249881b45944a870a616abf75ff4386615ea
    Reviewed-on: http://gerrit.cloudera.org:8080/14156
    Reviewed-by: Greg Rahn <gr...@cloudera.com>
    Tested-by: Impala Public Jenkins <im...@cloudera.com>
---
 docs/topics/impala_string_functions.xml | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

diff --git a/docs/topics/impala_string_functions.xml b/docs/topics/impala_string_functions.xml
index 2d2c760..c21fbd0 100644
--- a/docs/topics/impala_string_functions.xml
+++ b/docs/topics/impala_string_functions.xml
@@ -454,7 +454,9 @@ SELECT chr(97);
 
         <dd>
           <b>Purpose:</b> Returns a single string representing all the argument values joined
-          together.
+          together. If any argument is <codeph>NULL</codeph>, it returns <codeph>NULL</codeph>.
+          <p></p>
+
           <p>
             <b>Return type:</b> <codeph>STRING</codeph>
           </p>
@@ -1423,26 +1425,33 @@ select replace('hello world','xyz','abc');
             The <varname>delimiter</varname> can consist of multiple characters, not just a
             single character.
           </p>
+
           <p>
             All matching of the delimiter is done exactly, not using any regular expression
             patterns.
           </p>
+
           <p>
             <b>Return type:</b> <codeph>STRING</codeph>
           </p>
+
           <p conref="../shared/impala_common.xml#common/example_blurb"
               />
+
           <p>
             <codeph>SPLIT_PART('x,y,z',',',2)</codeph> returns <codeph>'y'</codeph>.
           </p>
+
           <p>
             <codeph>SPLIT_PART('one***two***three','***',2)</codeph> returns
             <codeph>'two'</codeph>.
           </p>
+
           <p>
             <codeph>SPLIT_PART('abc@@def@@ghi', '@@', 3)</codeph> returns
             <codeph>'ghi'</codeph>.
           </p>
+
           <p>
             <codeph>SPLIT_PART('abc@@def@@ghi', '@@', -3)</codeph> returns
             <codeph>'abc'</codeph>.