You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Vova Vysotskyi (Jira)" <ji...@apache.org> on 2019/11/05 17:43:00 UTC

[jira] [Created] (DRILL-7438) Add support for SAMPLE statistics collecting

Vova Vysotskyi created DRILL-7438:
-------------------------------------

             Summary: Add support for SAMPLE 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
             Fix For: Future


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}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)