Repository: drill Updated Branches: refs/heads/gh-pages 27f391044 -> 10186e7fd
edit Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/10186e7f Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/10186e7f Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/10186e7f Branch: refs/heads/gh-pages Commit: 10186e7fdfc3ab204ad402dd40ed31b084abdded Parents: 27f3910 Author: Bridget Bevens <[email protected]> Authored: Mon Mar 26 11:24:39 2018 -0700 Committer: Bridget Bevens <[email protected]> Committed: Mon Mar 26 11:24:39 2018 -0700 ---------------------------------------------------------------------- .../026-parquet-filter-pushdown.md | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/10186e7f/_docs/performance-tuning/026-parquet-filter-pushdown.md ---------------------------------------------------------------------- diff --git a/_docs/performance-tuning/026-parquet-filter-pushdown.md b/_docs/performance-tuning/026-parquet-filter-pushdown.md index 92a0d41..e027a89 100644 --- a/_docs/performance-tuning/026-parquet-filter-pushdown.md +++ b/_docs/performance-tuning/026-parquet-filter-pushdown.md @@ -1,6 +1,6 @@ --- title: "Parquet Filter Pushdown" -date: 2018-03-26 18:15:24 UTC +date: 2018-03-26 18:24:40 UTC parent: "Performance Tuning" --- @@ -48,11 +48,11 @@ The following table lists the supported and unsupported clauses, operators, data **Note:** An asterisk (*) indicates support as of Drill 1.13 -| Type | Supported | Not Supported | -|------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------| -| Clauses | WHERE, *WITH, HAVING (HAVING is supported if Drill can pass the filter through GROUP BY.) | None | -| Operators | AND, OR, NOT, *IS [NOT] NULL, *IS [NOT] TRUE|FALSE, IN (An IN list is converted to OR if the number in the IN list is within a certain threshold, for example 20. If greater than the threshold, pruning cannot occur.) | ITEM (Drill does not push the filter past the ITEM operator, which is used for complex fields.) | -| Comparison Operators | <>, <, >, <=, >=, = | None | -| Data Types | INT, BIGINT, FLOAT, DOUBLE, DATE, TIMESTAMP, TIME, *BOOLEAN (true|false) | CHAR, VARCHAR columns, Hive TIMESTAMP | -| Function | CAST is supported among the following types only: int, bigint, float, double, *date, *timestamp, and *time | None | -| Other | Files with multiple row groups | Joins, Enabled Native Hive reader | \ No newline at end of file +| | Supported | Not Supported | +|------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------| +| Clauses | WHERE, *WITH, HAVING (HAVING is supported if Drill can pass the filter through GROUP BY.) | None | +| Operators | AND, OR, NOT, *IS [NOT] NULL, *IS [NOT] TRUE, *IS [NOT] FALSE, IN (An IN list is converted to OR if the number in the IN list is within a certain threshold, for example 20. If greater than the threshold, pruning cannot occur.) | ITEM (Drill does not push the filter past the ITEM operator, which is used for complex fields.) | +| Comparison Operators | <>, <, >, <=, >=, = | None | +| Data Types | INT, BIGINT, FLOAT, DOUBLE, DATE, TIMESTAMP, TIME, *BOOLEAN (true, false) | CHAR, VARCHAR columns, Hive TIMESTAMP | +| Function | CAST is supported among the following types only: int, bigint, float, double, *date, *timestamp, and *time | None | +| Other | Files with multiple row groups | Joins, Enabled Native Hive reader | \ No newline at end of file
