You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Vitalii Diravka (JIRA)" <ji...@apache.org> on 2018/10/11 13:24:00 UTC

[jira] [Resolved] (DRILL-5192) REFRESH table METADATA as default system option

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

Vitalii Diravka resolved DRILL-5192.
------------------------------------
    Resolution: Won't Fix
      Assignee: Vitalii Diravka

[~bgajjela] Once you perform the query and the data is changed after last {{REFRESH TABLE}}, the metadata cache files are regenerated automatically. No need to perform {{REFRESH METADATA TABLE}}.
 See details in [docs|https://drill.apache.org/docs/optimizing-parquet-metadata-reading/#generating-the-parquet-metadata-cache-file] and [code|https://github.com/apache/drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/store/parquet/metadata/Metadata.java#L642].

Also the new "Metadata Management" work aka "Drill Metastore" is in progress. If you have suggestions, please put them in DRILL-6552

> REFRESH table METADATA as default system option 
> ------------------------------------------------
>
>                 Key: DRILL-5192
>                 URL: https://issues.apache.org/jira/browse/DRILL-5192
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Functions - Drill
>    Affects Versions: 1.2.0, 1.3.0, 1.4.0, 1.5.0, 1.6.0, 1.7.0, 1.8.0
>         Environment: maprfs
>            Reporter: bharath kumar
>            Assignee: Vitalii Diravka
>            Priority: Major
>
> Hi,
> We have a batch use case where files are loaded daily , we run REFRESH METADATA TABLE; for more performance on these files. How can we automate this refresh metadata table; at drill configuration level for specific table.
> Thanks,
> Bharath



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)