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 2020/03/02 08:33:00 UTC

[jira] [Updated] (DRILL-7477) Allow passing table function parameters into ANALYZE statement

     [ https://issues.apache.org/jira/browse/DRILL-7477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vova Vysotskyi updated DRILL-7477:
----------------------------------
    Description: 
It would be useful to allow passing table function parameters into ANALYZE statement.

One of the use-cases is to pass the inlined table schema to use it when producing ANALYZE.

Example of the command:
{code:sql}
ANALYZE TABLE table(dfs.`table_name` (type => 'parquet', autoCorrectCorruptDates => false, enableStringsSignedMinMax=>false, schema=>'inline=(mykey int, col_notexist varchar)')) REFRESH METADATA;
{code}

  was:
It would be useful to allow passing table function parameters into ANALYZE statement.

One of the use-cases is to pass the inlined table schema to use it when producing ANALYZE.


> Allow passing table function parameters into ANALYZE statement
> --------------------------------------------------------------
>
>                 Key: DRILL-7477
>                 URL: https://issues.apache.org/jira/browse/DRILL-7477
>             Project: Apache Drill
>          Issue Type: Sub-task
>    Affects Versions: 1.17.0
>            Reporter: Vova Vysotskyi
>            Assignee: Vova Vysotskyi
>            Priority: Major
>             Fix For: 1.18.0
>
>
> It would be useful to allow passing table function parameters into ANALYZE statement.
> One of the use-cases is to pass the inlined table schema to use it when producing ANALYZE.
> Example of the command:
> {code:sql}
> ANALYZE TABLE table(dfs.`table_name` (type => 'parquet', autoCorrectCorruptDates => false, enableStringsSignedMinMax=>false, schema=>'inline=(mykey int, col_notexist varchar)')) REFRESH METADATA;
> {code}



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