You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Vitalii Diravka (JIRA)" <ji...@apache.org> on 2019/03/19 09:40:00 UTC
[jira] [Commented] (DRILL-7114) ANALYZE command generates warnings
for stats file and materialization
[ https://issues.apache.org/jira/browse/DRILL-7114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16795881#comment-16795881 ]
Vitalii Diravka commented on DRILL-7114:
----------------------------------------
It can be reproduced not only for ANALYZE TABLE command, but for SELECT queries too (drill-embedded mode, drill master version):
{code}
0: jdbc:drill:zk=local> use dfs.tmp;
+-------+--------------------------------------+
| ok | summary |
+-------+--------------------------------------+
| true | Default schema changed to [dfs.tmp] |
+-------+--------------------------------------+
1 row selected (0.135 seconds)
0: jdbc:drill:zk=local> create table temp_t as select * from (VALUES(1));
+-----------+----------------------------+
| Fragment | Number of records written |
+-----------+----------------------------+
| 0_0 | 1 |
+-----------+----------------------------+
1 row selected (0.65 seconds)
0: jdbc:drill:zk=local> select * from temp_t;
+---------+
| EXPR$0 |
+---------+
| 1 |
+---------+
1 row selected (0.198 seconds)
{code}
> ANALYZE command generates warnings for stats file and materialization
> ---------------------------------------------------------------------
>
> Key: DRILL-7114
> URL: https://issues.apache.org/jira/browse/DRILL-7114
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Aman Sinha
> Assignee: Gautam Parai
> Priority: Minor
> Fix For: 1.16.0
>
>
> When I run ANALYZE, I see warnings in the log file as shown below. The ANALYZE command should not try to read the stats file or materialize the stats.
> {noformat}
> 12:04:32.939 [2370143e-c419-f33c-d879-84989712bc85:foreman] WARN o.a.d.e.p.common.DrillStatsTable - Failed to read the stats file.
> java.io.FileNotFoundException: File /tmp/orders3/.stats.drill/0_0.json does not exist
> 12:04:32.939 [2370143e-c419-f33c-d879-84989712bc85:foreman] WARN o.a.d.e.p.common.DrillStatsTable - Failed to materialize the stats. Continuing without stats.
> java.io.FileNotFoundException: File /tmp/orders3/.stats.drill/0_0.json does not exist
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)