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

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-2810:
----------------------------------
    Fix Version/s: 1.2.0

> 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
>             Fix For: 1.2.0
>
>
> 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)