[
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)
