drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deneche A. Hakim (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4427) Table not found when querying a parquet table with metadata cache
Date Fri, 26 Feb 2016 15:21:18 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15169179#comment-15169179
] 

Deneche A. Hakim commented on DRILL-4427:
-----------------------------------------

Please note that the content of the metadata cache file isn't really relevant to the issue
here. The query fails even before the cache file is read

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

Mime
View raw message