Repository: impala Updated Branches: refs/heads/master 93ee538c5 -> de0c6bd6b
[DOCS] 2 Typos fixed in NVL2 examples Change-Id: Ib3ac978398eb3de1877e3cd26f662a34c3f131d0 Reviewed-on: http://gerrit.cloudera.org:8080/11795 Reviewed-by: Alex Rodoni <[email protected]> Tested-by: Impala Public Jenkins <[email protected]> Project: http://git-wip-us.apache.org/repos/asf/impala/repo Commit: http://git-wip-us.apache.org/repos/asf/impala/commit/9bd22a3c Tree: http://git-wip-us.apache.org/repos/asf/impala/tree/9bd22a3c Diff: http://git-wip-us.apache.org/repos/asf/impala/diff/9bd22a3c Branch: refs/heads/master Commit: 9bd22a3ce65a3186153b5d7988eae2bb48559b26 Parents: 93ee538 Author: Alex Rodoni <[email protected]> Authored: Thu Oct 25 19:05:07 2018 -0700 Committer: Alex Rodoni <[email protected]> Committed: Fri Oct 26 02:17:07 2018 +0000 ---------------------------------------------------------------------- docs/topics/impala_conditional_functions.xml | 27 +++++++++-------------- 1 file changed, 11 insertions(+), 16 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/impala/blob/9bd22a3c/docs/topics/impala_conditional_functions.xml ---------------------------------------------------------------------- diff --git a/docs/topics/impala_conditional_functions.xml b/docs/topics/impala_conditional_functions.xml index 78dd62a..b500091 100644 --- a/docs/topics/impala_conditional_functions.xml +++ b/docs/topics/impala_conditional_functions.xml @@ -677,24 +677,19 @@ END</codeblock> </dt> <dd> - <b>Purpose:</b> Returns the second argument, <codeph>ifNotNull</codeph>, if the first - argument is not <codeph>NULL</codeph>. Returns the third argument, - <codeph>ifNull</codeph>, if the first argument is <codeph>NULL</codeph>. - <p> - Equivalent to the <codeph>NVL2()</codeph> function in Oracle Database. - </p> - - <p> - <b>Return type:</b> Same as the first argument value - </p> - + <b>Purpose:</b> Returns the second argument, + <codeph>ifNotNull</codeph>, if the first argument is not + <codeph>NULL</codeph>. Returns the third argument, + <codeph>ifNull</codeph>, if the first argument is + <codeph>NULL</codeph>. <p> Equivalent to the <codeph>NVL2()</codeph> + function in Oracle Database. </p> + <p> + <b>Return type:</b> Same as the first argument value </p> <p conref="../shared/impala_common.xml#common/added_in_290"/> - - <p conref="../shared/impala_common.xml#common/example_blurb" - /> -<codeblock> + <p conref="../shared/impala_common.xml#common/example_blurb"/> + <codeblock> SELECT NVL2(NULL, 999, 0); -- Returns 0 -SELECT NVL2('ABC', 'Is Null', 'Is Not Null); -- Returns 'Is Not Null'</codeblock> +SELECT NVL2('ABC', 'Is Not Null', 'Is Null'); -- Returns 'Is Not Null'</codeblock> </dd> </dlentry>
