[DRILL-7257] [Text V3 Reader] dir0 is empty if a column filter returns all lines.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.17.0
• Labels: ready-to-commit
• Assignee: Paul Rogers
• Reporter: Anton Gozhiy
• Reviewer: Arina Ielchiieva
• Created: 14/May/19 10:44
• Updated: 10/Jun/19 11:33
• Resolved: 24/May/19 16:31

Description

Data:
Unzip the attached archive: lineitempart.zip.

Steps:

1. Set exec.storage.enable_v3_text_reader=true
2. Run the following query:

   select columns[0], dir0 from dfs.tmp.`/drill/data/lineitempart` where dir0=1994 and columns[0]>29766 order by columns[0] limit 1;
   

Expected result:

+--------+------+
| EXPR$0 | dir0 |
+--------+------+
| 29767  | 1994 |
+--------+------+

Actual result:

+--------+------+
| EXPR$0 | dir0 |
+--------+------+
| 29767  |      |
+--------+------+

Note: If change filter a bit so it doesn't return all lines, everything is ok:

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 |
+--------+------+

Issue Links

• links to: GitHub Pull Request #1790