You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Anton Gozhiy (JIRA)" <ji...@apache.org> on 2019/05/14 10:45:00 UTC
[jira] [Created] (DRILL-7257) [Text V3 Reader] dir0 is empty if a
column filter returns all lines.
Anton Gozhiy created DRILL-7257:
-----------------------------------
Summary: [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
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)