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/06/16 22:46:04 UTC
[jira] [Updated] (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:all-tabpanel ]
Jacques Nadeau updated DRILL-990:
---------------------------------
Fix Version/s: 1.0.0-BETA2
> 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
> Fix For: 1.0.0-BETA2
>
>
> 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)