[DRILL-2810] Attempt to use dir0 on a table that is not partitioned results in exception

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Fix Version/s: Future
• Component/s: Query Planning & Optimization
• Assignee: Paul Rogers
• Reporter: Victoria Markman
• Created: 16/Apr/15 23:57
• Updated: 19/Jun/17 00:40

Description

j2 is a table, not partitioned:

[Thu Apr 16 16:32:53 root@/mapr/vmarkman.cluster.com/drill/testdata/joins/j2 ] # ls -l
total 3
-rwxr-xr-x 1 root root 2399 Mar  5 16:53 0_0_0.parquet

0: jdbc:drill:schema=dfs> select * from `j2` where dir0 = '2015';
Query failed: SYSTEM ERROR: Unexpected exception during fragment initialization: Internal error: Error while applying rule PruneScanRule:Filter_On_Scan, args [rel#57816:DrillFilterRel.LOGICAL.ANY([]).[](child=rel#57813:Subset#0.LOGICAL.ANY([]).[],condition==($1, '2015')), rel#57817:DrillScanRel.LOGICAL.ANY([]).[](table=[dfs, joins, j2],groupscan=ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:/drill/testdata/joins/j2]], selectionRoot=/drill/testdata/joins/j2, numFiles=1, columns=[`*`]])]

[899eb65e-2b2f-41c7-a7ee-72b831fdb429 on atsqa4-133.qa.lab:31010]

Error: exception while executing query: Failure while executing query. (state=,code=0)

If you create a directory under j2 (2015), query works:

0: jdbc:drill:schema=dfs> select c_varchar from j2 where dir0='2015' limit 1;
+------------+
| c_varchar  |
+------------+
| 0000 000000 00000 |
+------------+
1 row selected (0.155 seconds)

0: jdbc:drill:schema=dfs> select c_varchar from j2 where dir0='2014' limit 1;
+------------+
| c_varchar  |
+------------+
+------------+
No rows selected (0.243 seconds)