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

["Victoria Markman (JIRA)" <ji...@apache.org>]

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)