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>.