You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/07/21 04:49:40 UTC
[jira] [Commented] (DRILL-990) Add the mutability of a schema into
INFORMATION_SCHEMA.SCHEMATA
[ https://issues.apache.org/jira/browse/DRILL-990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14068130#comment-14068130 ]
Jacques Nadeau commented on DRILL-990:
--------------------------------------
fixed by e5c2da0 or earlier
> 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
>
> Attachments: DRILL-990-Add-schema-mutability-property-to-InfoSche.patch
>
>
> 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)