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