[DRILL-6945] Update INFORMATION_SCHEMA.SCHEMATA table description

• Type: Task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.15.0
• Component/s: Documentation
• Labels: doc-impacting
• Assignee: Bridget Bevens
• Reporter: Arina Ielchiieva
• Created: 04/Jan/19 11:07
• Updated: 04/Nov/19 12:48

Description

https://drill.apache.org/docs/querying-the-information-schema/

Currently documentation states that SCHEMA table contains only several columns:

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.

In reality it contains far more columns (especially TYPE and IS_MUTABLE) which can be considered to be documented:

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         |