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