IMPALA-3267 [DOCS] Docs about nan/inf are incorrect Switched the example for Infinity and NaN in the impala.common file so it will be correct every- where this example is used in the Impala documentation. Instead of saying, "pow(-1, 0.5) returns infinity and 1/0 returns NaN" it has been corrected to "1/0 returns infinity and pow(-1, 0.5) returns NaN."
Change-Id: I0e5d950b250c2e4425bde7d9e0bccbb068a73e12 Reviewed-on: http://gerrit.cloudera.org:8080/7083 Reviewed-by: Todd Lipcon <[email protected]> Reviewed-by: Michael Brown <[email protected]> Tested-by: Impala Public Jenkins Project: http://git-wip-us.apache.org/repos/asf/incubator-impala/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-impala/commit/98ae318a Tree: http://git-wip-us.apache.org/repos/asf/incubator-impala/tree/98ae318a Diff: http://git-wip-us.apache.org/repos/asf/incubator-impala/diff/98ae318a Branch: refs/heads/master Commit: 98ae318a149e4496221b366e68064b9167be8e99 Parents: ce31572 Author: Laurel Hale <[email protected]> Authored: Mon Jun 5 13:27:16 2017 -0700 Committer: Impala Public Jenkins <[email protected]> Committed: Mon Jun 5 22:39:54 2017 +0000 ---------------------------------------------------------------------- docs/shared/impala_common.xml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/98ae318a/docs/shared/impala_common.xml ---------------------------------------------------------------------- diff --git a/docs/shared/impala_common.xml b/docs/shared/impala_common.xml index e75cd00..8bd3cbb 100644 --- a/docs/shared/impala_common.xml +++ b/docs/shared/impala_common.xml @@ -1305,8 +1305,8 @@ select c_first_name, c_last_name from customer where lower(trim(c_last_name)) rl <p id="infinity_and_nan" rev="IMPALA-3267"> Infinity and NaN can be specified in text data files as <codeph>inf</codeph> and <codeph>nan</codeph> respectively, and Impala interprets them as these special values. They can also be produced by certain - arithmetic expressions; for example, <codeph>pow(-1, 0.5)</codeph> returns <codeph>Infinity</codeph> and - <codeph>1/0</codeph> returns <codeph>NaN</codeph>. Or you can cast the literal values, such as <codeph>CAST('nan' AS + arithmetic expressions; for example, <codeph>1/0</codeph> returns <codeph>Infinity</codeph> and + <codeph>pow(-1, 0.5)</codeph> returns <codeph>NaN</codeph>. Or you can cast the literal values, such as <codeph>CAST('nan' AS DOUBLE)</codeph> or <codeph>CAST('inf' AS DOUBLE)</codeph>. </p>
