[jira] [Created] (IMPALA-10890) Show pushed down predicates in query plan

["Quanlong Huang (Jira)" <ji...@apache.org>]

Quanlong Huang created IMPALA-10890:
---------------------------------------

             Summary: Show pushed down predicates in query plan
                 Key: IMPALA-10890
                 URL: https://issues.apache.org/jira/browse/IMPALA-10890
             Project: IMPALA
          Issue Type: Improvement
          Components: Frontend
            Reporter: Quanlong Huang


We push down predicates that can leverage parquet statistics. Similar works for ORC are on-going in IMPALA-6505 and IMPALA-10873. It'd be useful to show the final pushed down form of these predicates. E.g.
 * predicate '{{x = 5}}' is transformed into two predicates '{{x <= 5}}' and '{{x >= 5}}' for parquet.
 * predicate '{{x in [0, 50, 100]}}' is transformed into two predicates '{{x >= 0}}' and '{{x <= 100}}' for parquet.

The query plan only shows the original predicates in the line of "parquet statistics predicates:". It helps to understand the performance if the final predicates are also shown.

For ORC columns that have bloom filter enabled, we'd like to push down the IN-list predicate directly instead of transformed it into range predicates. Showing the final predicates make this visible.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org