drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-990) Add the mutability of a schema into INFORMATION_SCHEMA.SCHEMATA
Date Tue, 08 Jul 2014 00:23:34 GMT

     [ https://issues.apache.org/jira/browse/DRILL-990?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-990:
---------------------------------

    Assignee: Venki Korukanti

> 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
>            Assignee: Venki Korukanti
>             Fix For: 1.0.0-BETA1
>
>
> 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)

Mime
View raw message