[
https://issues.apache.org/jira/browse/DRILL-4427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Deneche A. Hakim updated DRILL-4427:
------------------------------------
Attachment: drill.parquet_metadata
attached metadata cache file
> Table not found when querying a parquet table with metadata cache
> -----------------------------------------------------------------
>
> Key: DRILL-4427
> URL: https://issues.apache.org/jira/browse/DRILL-4427
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.5.0
> Reporter: Deneche A. Hakim
> Fix For: 1.6.0
>
> Attachments: drill.parquet_metadata
>
>
> The following query runs fine without metadata cache but fails when metadata
> cache is available:
> {noformat}
> 0: jdbc:drill:zk=local> select count(*) from `tpch10/lineitem/*`;
> +-----------+
> | EXPR$0 |
> +-----------+
> | 59986052 |
> +-----------+
> 1 row selected (0.148 seconds)
> 0: jdbc:drill:zk=local> refresh table metadata `tpch10/lineitem`;
> +-------+-----------------------------------------------------------+
> | ok | summary |
> +-------+-----------------------------------------------------------+
> | true | Successfully updated metadata for table tpch10/lineitem. |
> +-------+-----------------------------------------------------------+
> 1 row selected (0.182 seconds)
> 0: jdbc:drill:zk=local> select count(*) from `tpch10/lineitem/*`;
> Feb 23, 2016 10:30:42 AM
> org.apache.calcite.sql.validate.SqlValidatorException <init>
> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table
> 'tpch10/lineitem/*' not found
> Feb 23, 2016 10:30:42 AM org.apache.calcite.runtime.CalciteException <init>
> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1,
> column 22 to line 1, column 40: Table 'tpch10/lineitem/*' not found
> Error: VALIDATION ERROR: From line 1, column 22 to line 1, column 40: Table
> 'tpch10/lineitem/*' not found
> {noformat}
> Initial investigation shows that FileSelection.create(DrillFileSystem,
> String, String) calls fs.globStatus() without passing a DrillPathFilter which
> will return the metadata cache file on top of the selection.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
