[jira] [Updated] (DRILL-6945) Update INFORMATION_SCHEMA.SCHEMATA table description

["Arina Ielchiieva (Jira)" <ji...@apache.org>]

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

Arina Ielchiieva updated DRILL-6945:
------------------------------------
    Fix Version/s:     (was: 1.17.0)

> Update INFORMATION_SCHEMA.SCHEMATA table description
> ----------------------------------------------------
>
>                 Key: DRILL-6945
>                 URL: https://issues.apache.org/jira/browse/DRILL-6945
>             Project: Apache Drill
>          Issue Type: Task
>          Components: Documentation
>    Affects Versions: 1.15.0
>            Reporter: Arina Ielchiieva
>            Assignee: Bridget Bevens
>            Priority: Major
>              Labels: doc-impacting
>
> https://drill.apache.org/docs/querying-the-information-schema/
> Currently documentation states that SCHEMA table contains only several columns:
> {noformat}
> The SCHEMATA table contains the CATALOG_NAME and SCHEMA_NAME columns. To allow maximum flexibility inside BI tools, the only catalog that Drill supports is DRILL.
> {noformat}
> In reality it contains far more columns (especially TYPE and IS_MUTABLE) which can be considered to be documented:
> {noformat}
> drill (information_schema)>select * from schemata;
> +---------------+----------------------+---------------+----------------+-------------+
> | CATALOG_NAME  |     SCHEMA_NAME      | SCHEMA_OWNER  |      TYPE      | IS_MUTABLE  |
> +---------------+----------------------+---------------+----------------+-------------+
> | DRILL         | cp.default           | <owner>       | file           | NO          |
> | DRILL         | dfs.default          | <owner>       | file           | NO          |
> | DRILL         | dfs.myschemainitcap  | <owner>       | file           | YES         |
> {noformat}



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