You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Deneche A. Hakim (JIRA)" <ji...@apache.org> on 2016/02/23 19:35:18 UTC
[jira] [Created] (DRILL-4427) Table not found when querying a
parquet table with metadata cache
Deneche A. Hakim created DRILL-4427:
---------------------------------------
Summary: 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
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)