Return-Path: 
 <issues-return-2593-apmail-drill-issues-archive=drill.apache.org@drill.incubator.apache.org>
X-Original-To: apmail-drill-issues-archive@minotaur.apache.org
Delivered-To: apmail-drill-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 2EB8511604
	for <apmail-drill-issues-archive@minotaur.apache.org>;
 Tue,  8 Jul 2014 00:24:03 +0000 (UTC)
Received: (qmail 53787 invoked by uid 500); 8 Jul 2014 00:24:03 -0000
Delivered-To: apmail-drill-issues-archive@drill.apache.org
Received: (qmail 53763 invoked by uid 500); 8 Jul 2014 00:24:03 -0000
Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.incubator.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.incubator.apache.org>
List-Post: <mailto:issues@drill.incubator.apache.org>
List-Id: <issues.drill.incubator.apache.org>
Reply-To: dev@drill.incubator.apache.org
Delivered-To: mailing list issues@drill.incubator.apache.org
Received: (qmail 53753 invoked by uid 99); 8 Jul 2014 00:24:03 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Jul 2014 00:24:03 +0000
X-ASF-Spam-Status: No, hits=-2000.7 required=5.0
	tests=ALL_TRUSTED,RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3)
    by apache.org (qpsmtpd/0.29) with SMTP; Tue, 08 Jul 2014 00:24:04 +0000
Received: (qmail 51483 invoked by uid 99); 8 Jul 2014 00:23:34 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Jul 2014 00:23:34 +0000
Date: Tue, 8 Jul 2014 00:23:34 +0000 (UTC)
From: "Jacques Nadeau (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12721349.1402902911957.16372.1404779014154@arcas>
In-Reply-To: <JIRA.12721349.1402902911957@arcas>
References: <JIRA.12721349.1402902911957@arcas>
Subject: [jira] [Updated] (DRILL-990) Add the mutability of a schema into
 INFORMATION_SCHEMA.SCHEMATA
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


     [ 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:     (was: 1.0.0-BETA2)
                   1.0.0-BETA1

> 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-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)