You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Vova Vysotskyi (Jira)" <ji...@apache.org> on 2019/11/05 18:28:00 UTC
[jira] [Updated] (DRILL-7438) Add support for ESTIMATE statistics
collecting
[ https://issues.apache.org/jira/browse/DRILL-7438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vova Vysotskyi updated DRILL-7438:
----------------------------------
Description:
Add support for ESTIMATE statistics collecting.
Query syntax:
{code:sql}
ANALYZE TABLE [table_name] {COMPUTE | ESTIMATE} | STATISTICS [(column1, column2, ...)] [ SAMPLE numeric PERCENT;
ANALYZE TABLE [table_name] [COLUMNS (col1, col2, ...)] REFRESH METADATA [partition LEVEL] {COMPUTE | ESTIMATE} | STATISTICS [(column1, column2, ...)] [ SAMPLE numeric PERCENT ]
{code}
was:
Add support for SAMPLE statistics collecting.
Query syntax:
{code:sql}
ANALYZE TABLE [table_name] {COMPUTE | ESTIMATE} | STATISTICS [(column1, column2, ...)] [ SAMPLE numeric PERCENT;
ANALYZE TABLE [table_name] [COLUMNS (col1, col2, ...)] REFRESH METADATA [partition LEVEL] {COMPUTE | ESTIMATE} | STATISTICS [(column1, column2, ...)] [ SAMPLE numeric PERCENT ]
{code}
> Add support for ESTIMATE statistics collecting
> ----------------------------------------------
>
> Key: DRILL-7438
> URL: https://issues.apache.org/jira/browse/DRILL-7438
> Project: Apache Drill
> Issue Type: Improvement
> Affects Versions: 1.17.0
> Reporter: Vova Vysotskyi
> Priority: Major
> Fix For: Future
>
>
> Add support for ESTIMATE statistics collecting.
> Query syntax:
> {code:sql}
> ANALYZE TABLE [table_name] {COMPUTE | ESTIMATE} | STATISTICS [(column1, column2, ...)] [ SAMPLE numeric PERCENT;
> ANALYZE TABLE [table_name] [COLUMNS (col1, col2, ...)] REFRESH METADATA [partition LEVEL] {COMPUTE | ESTIMATE} | STATISTICS [(column1, column2, ...)] [ SAMPLE numeric PERCENT ]
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)