[
https://issues.apache.org/jira/browse/DRILL-7257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anton Gozhiy closed DRILL-7257.
-------------------------------
Verified with Drill version 1.17.0-SNAPSHOT (commit
2615d68de4e44b1f03f5c047018548c06a7396b4)
Checked with different filter values and operators.
> [Text V3 Reader] dir0 is empty if a column filter returns all lines.
> --------------------------------------------------------------------
>
> Key: DRILL-7257
> URL: https://issues.apache.org/jira/browse/DRILL-7257
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.16.0
> Reporter: Anton Gozhiy
> Assignee: Paul Rogers
> Priority: Major
> Labels: ready-to-commit
> Fix For: 1.17.0
>
> Attachments: lineitempart.zip
>
>
> *Data:*
> Unzip the attached archive: lineitempart.zip.
> *Steps:*
> # Set exec.storage.enable_v3_text_reader=true
> # Run the following query:
> {code:sql}
> select columns[0], dir0 from dfs.tmp.`/drill/data/lineitempart` where
> dir0=1994 and columns[0]>29766 order by columns[0] limit 1;
> {code}
> *Expected result:*
> {noformat}
> +--------+------+
> | EXPR$0 | dir0 |
> +--------+------+
> | 29767 | 1994 |
> +--------+------+
> {noformat}
> *Actual result:*
> {noformat}
> +--------+------+
> | EXPR$0 | dir0 |
> +--------+------+
> | 29767 | |
> +--------+------+
> {noformat}
> *Note:* If change filter a bit so it doesn't return all lines, everything is
> ok:
> {noformat}
> apache drill> select columns[0], dir0 from dfs.tmp.`/drill/data/lineitempart`
> where dir0=1994 and columns[0]>29767 order by columns[0] limit 1;
> +--------+------+
> | EXPR$0 | dir0 |
> +--------+------+
> | 29792 | 1994 |
> +--------+------+
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
