You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Bridget Bevens (JIRA)" <ji...@apache.org> on 2019/03/08 23:23:00 UTC
[jira] [Updated] (DRILL-7085) Drill Statistics: analyze table cmd
fails
[ https://issues.apache.org/jira/browse/DRILL-7085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bridget Bevens updated DRILL-7085:
----------------------------------
Description:
On the latest build we are seeing in the regression results that the analyze cmd is failing.
This is the dir:
{code:java}
[root@qa101-108 bin]# hadoop fs -ls /drill/testdat03-05 18:26 /drill/testdata/a/table_stats/data_with_0 Found 1 items -rwxr-xr-x 3 root root 487 2019-table_stats/data_with_0/0_0_0.parquet
{code}
{code:java}
0: jdbc:drill:drillbit=10.10.101.108> set `planner.statistics.use`=true;
+-------+----------------------------------+
| ok | summary |
+-------+----------------------------------+
| true | planner.statistics.use updated. |
+-------+----------------------------------+
1 row selected (0.164 seconds)
{code}
{code:java}
0: jdbc:drill:drillbit=10.10.101.108> analyze table `table_stats/data_with_0` compute statistics;
+--------+----------------------------------------------------------------------------------+
| ok | summary |
+--------+----------------------------------------------------------------------------------+
| false | Table table_stats/data_with_0 is not supported by ANALYZE. Support is currently limited to directory-based Parquet tables. |
+--------+----------------------------------------------------------------------------------+
1 row selected (0.901 seconds)
{code}
was:
On the latest build we are seeing in the regression results that the analyze cmd is failing.
This is the dir:
{code:java}
[root@qa101-108 bin]# hadoop fs -ls /drill/testdata/table_stats/data_with_0 Found 1 items -rwxr-xr-x 3 root root 487 2019-03-05 18:26 /drill/testdata/table_stats/data_with_0/0_0_0.parquet
{code}
{code:java}
0: jdbc:drill:drillbit=10.10.101.108> set `planner.statistics.use`=true;
+-------+----------------------------------+
| ok | summary |
+-------+----------------------------------+
| true | planner.statistics.use updated. |
+-------+----------------------------------+
1 row selected (0.164 seconds)
{code}
{code:java}
0: jdbc:drill:drillbit=10.10.101.108> analyze table `table_stats/data_with_0` compute statistics;
+--------+----------------------------------------------------------------------------------+
| ok | summary |
+--------+----------------------------------------------------------------------------------+
| false | Table table_stats/data_with_0 is not supported by ANALYZE. Support is currently limited to directory-based Parquet tables. |
+--------+----------------------------------------------------------------------------------+
1 row selected (0.901 seconds)
{code}
> Drill Statistics: analyze table cmd fails
> -----------------------------------------
>
> Key: DRILL-7085
> URL: https://issues.apache.org/jira/browse/DRILL-7085
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.16.0
> Reporter: Anisha Reddy
> Assignee: Gautam Parai
> Priority: Blocker
> Fix For: 1.16.0
>
>
> On the latest build we are seeing in the regression results that the analyze cmd is failing.
> This is the dir:
> {code:java}
> [root@qa101-108 bin]# hadoop fs -ls /drill/testdat03-05 18:26 /drill/testdata/a/table_stats/data_with_0 Found 1 items -rwxr-xr-x 3 root root 487 2019-table_stats/data_with_0/0_0_0.parquet
> {code}
> {code:java}
> 0: jdbc:drill:drillbit=10.10.101.108> set `planner.statistics.use`=true;
> +-------+----------------------------------+
> | ok | summary |
> +-------+----------------------------------+
> | true | planner.statistics.use updated. |
> +-------+----------------------------------+
> 1 row selected (0.164 seconds)
> {code}
> {code:java}
> 0: jdbc:drill:drillbit=10.10.101.108> analyze table `table_stats/data_with_0` compute statistics;
> +--------+----------------------------------------------------------------------------------+
> | ok | summary |
> +--------+----------------------------------------------------------------------------------+
> | false | Table table_stats/data_with_0 is not supported by ANALYZE. Support is currently limited to directory-based Parquet tables. |
> +--------+----------------------------------------------------------------------------------+
> 1 row selected (0.901 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)