[impala] branch master updated: IMPALA-8745: [DOCS] More details on INITCAP() function

[ar...@apache.org]

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

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


The following commit(s) were added to refs/heads/master by this push:
     new 433640c  IMPALA-8745: [DOCS] More details on INITCAP() function
433640c is described below

commit 433640ccdc5231a3be2ebe2029c2ee51c193bea7
Author: Alex Rodoni <ar...@cloudera.com>
AuthorDate: Mon Jul 8 14:07:05 2019 -0700

    IMPALA-8745: [DOCS] More details on INITCAP() function
    
    Change-Id: Iffead7bd8a8dab80992751cdde743165b9720ead
    Reviewed-on: http://gerrit.cloudera.org:8080/13814
    Reviewed-by: Alex Rodoni <ar...@cloudera.com>
    Tested-by: Impala Public Jenkins <im...@cloudera.com>
---
 docs/topics/impala_string_functions.xml | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

diff --git a/docs/topics/impala_string_functions.xml b/docs/topics/impala_string_functions.xml
index 356f700..6143a83 100644
--- a/docs/topics/impala_string_functions.xml
+++ b/docs/topics/impala_string_functions.xml
@@ -539,10 +539,18 @@ SELECT chr(97);
         </dt>
 
         <dd>
-          <b>Purpose:</b> Returns the input string with the first letter capitalized.
+          <b>Purpose:</b> Returns the input string with the first letter of each word
+          capitalized and all other letters in lowercase.
           <p>
             <b>Return type:</b> <codeph>STRING</codeph>
           </p>
+          <p>
+            <b>Example: </b>
+          </p>
+          <p>
+            <codeph>INITCAP("i gOt mY HorSeS in tHe bacK")</codeph> returns <codeph>"I Got My
+            Horses In The Back"</codeph>.
+          </p>
         </dd>
 
       </dlentry>
@@ -560,7 +568,6 @@ SELECT chr(97);
           <p>
             <b>Return type:</b> <codeph>INT</codeph>
           </p>
-
           <p conref="../shared/impala_common.xml#common/usage_notes_blurb"/>
 
           <p>
@@ -812,6 +819,7 @@ select instr('foo bar bletch', 'b', 1, null);
           <p>
             <b>Example:</b>
           </p>
+
           <p>
             <codeph>LEVENSHTEIN ('welcome', 'We come')</codeph> returns 2, first change to
             replace '<codeph>w</codeph>' to '<codeph>W</codeph>', and then to replace