IMPALA-4859: [DOCS] Update example to show IS [NOT] NULL pushed to Kudu The discussion / illustration of which operators are pushed to Kudu is under the EXPLAIN topic.
Change-Id: I3af6d3dbb10528081603c103bf1c2be2e6fc51c3 Reviewed-on: http://gerrit.cloudera.org:8080/7066 Reviewed-by: Matthew Jacobs <[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/02eb18b1 Tree: http://git-wip-us.apache.org/repos/asf/incubator-impala/tree/02eb18b1 Diff: http://git-wip-us.apache.org/repos/asf/incubator-impala/diff/02eb18b1 Branch: refs/heads/master Commit: 02eb18b12b01af2c012d2313aae6498c15214bd1 Parents: edf9f2f Author: John Russell <[email protected]> Authored: Fri Jun 2 14:50:31 2017 -0700 Committer: Impala Public Jenkins <[email protected]> Committed: Tue Jun 6 18:15:27 2017 +0000 ---------------------------------------------------------------------- docs/topics/impala_explain.xml | 21 +++++++++++++-------- 1 file changed, 13 insertions(+), 8 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-impala/blob/02eb18b1/docs/topics/impala_explain.xml ---------------------------------------------------------------------- diff --git a/docs/topics/impala_explain.xml b/docs/topics/impala_explain.xml index fefe574..f338636 100644 --- a/docs/topics/impala_explain.xml +++ b/docs/topics/impala_explain.xml @@ -253,20 +253,25 @@ EXPLAIN_LEVEL set to extended and non-primary key column <codeph>Y</codeph>, you can see that some operators in the <codeph>WHERE</codeph> clause are evaluated immediately by Kudu and others are evaluated later by Impala: -<codeblock> + </p> + +<codeblock rev="2.9.0 IMPALA-4859"> EXPLAIN SELECT x,y from kudu_table WHERE - x = 1 AND x NOT IN (2,3) AND y = 1 - AND x IS NOT NULL AND x > 0; + x = 1 AND y NOT IN (2,3) AND z = 1 + AND a IS NOT NULL AND b > 0 AND length(s) > 5; +---------------- | Explain String +---------------- ... -| 00:SCAN KUDU [jrussell.hash_only] -| predicates: x IS NOT NULL, x NOT IN (2, 3) -| kudu predicates: x = 1, x > 0, y = 1 +| 00:SCAN KUDU [kudu_table] +| predicates: y NOT IN (2, 3), length(s) > 5 +| kudu predicates: a IS NOT NULL, b > 0, x = 1, z = 1 </codeblock> - Only binary predicates and <codeph>IN</codeph> predicates containing - literal values that exactly match the types in the Kudu table, and do not + + <p rev="2.9.0 IMPALA-4859"> + Only binary predicates, <codeph>IS NULL</codeph> and <codeph>IS NOT NULL</codeph> + (in <keyword keyref="impala29"/> and higher), and <codeph>IN</codeph> predicates + containing literal values that exactly match the types in the Kudu table, and do not require any casting, can be pushed to Kudu. </p>
