[jira] [Created] (DRILL-990) Add the mutability of a schema into INFORMATION_SCHEMA.SCHEMATA

["George Chow (JIRA)" <ji...@apache.org>]

George Chow created DRILL-990:
---------------------------------

             Summary: Add the mutability of a schema into INFORMATION_SCHEMA.SCHEMATA
                 Key: DRILL-990
                 URL: https://issues.apache.org/jira/browse/DRILL-990
             Project: Apache Drill
          Issue Type: New Feature
            Reporter: George Chow


I noticed that with DRILL-788 complete now, CREATE VIEW is only allowed for schema marked as writeable.

For example, in the following configuration, only the two workspaces "dfs.root" and "dfs.tmp" are writeable.

{code}
{
  "type" : "file",
  "enabled" : true,
  "connection" : "file:///",
  "workspaces" : {
    "root" : {
      "location" : "/",
      "writable" : true,
      "storageformat" : null
    },
    "tmp" : {
      "location" : "/tmp",
      "writable" : true,
      "storageformat" : "csv"
    }
  },
...
}
{code}

The current INFORMATION_SCHEMA.SCHEMATA looks as follow:
{code}
0: jdbc:drill:local=locaclhost:5181> select * from INFORMATION_SCHEMA.SCHEMATA;
+--------------+-------------+--------------+------------+
| CATALOG_NAME | SCHEMA_NAME | SCHEMA_OWNER |    TYPE    |
+--------------+-------------+--------------+------------+
| DRILL        | hive43.default | <owner>      | hive       |
| DRILL        | dfs.default | <owner>      | file       |
| DRILL        | dfs.root    | <owner>      | file       |
| DRILL        | dfs.tmp     | <owner>      | file       |
| DRILL        | cp.default  | <owner>      | file       |
| DRILL        | hbase       | <owner>      | hbase      |
| DRILL        | sys         | <owner>      | system-tables |
| DRILL        | INFORMATION_SCHEMA | <owner>      | ischema    |
+--------------+-------------+--------------+------------+
8 rows selected (5.085 seconds)
{code}

Adding a fifth column in ("IS_WRITEABLE") will allow a tool (e.g., Drill Explorer) to help a user in choosing the valid schema to save views into.
  



--
This message was sent by Atlassian JIRA
(v6.2#6252)