Arina Ielchiieva created DRILL-6945:
---------------------------------------
Summary: 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
Fix For: 1.16.0
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
(v7.6.3#76005)
