Victoria Markman created DRILL-2810:
---------------------------------------
Summary: Attempt to use dir0 on a table that is not partitioned
results in exception
Key: DRILL-2810
URL: https://issues.apache.org/jira/browse/DRILL-2810
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 0.9.0
Reporter: Victoria Markman
Assignee: Jinfeng Ni
j2 is a table, not partitioned:
{code}
[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
{code}
{code}
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)
{code}
If you create a directory under j2 (2015), query works:
{code}
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)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
