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

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

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)