Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6945

Update INFORMATION_SCHEMA.SCHEMATA table description

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.15.0
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:

      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         |
      

        Attachments

          Activity

            People

            • Assignee:
              bbevens Bridget Bevens
              Reporter:
              arina Arina Ielchiieva
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: