Return-Path: 
 <drill-user-return-686-apmail-incubator-drill-user-archive=incubator.apache.org@incubator.apache.org>
X-Original-To: apmail-incubator-drill-user-archive@minotaur.apache.org
Delivered-To: apmail-incubator-drill-user-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 274FD17FCF
	for <apmail-incubator-drill-user-archive@minotaur.apache.org>;
 Fri, 10 Oct 2014 05:20:25 +0000 (UTC)
Received: (qmail 86036 invoked by uid 500); 10 Oct 2014 05:20:25 -0000
Delivered-To: apmail-incubator-drill-user-archive@incubator.apache.org
Received: (qmail 85986 invoked by uid 500); 10 Oct 2014 05:20:25 -0000
Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:drill-user-help@incubator.apache.org>
List-Unsubscribe: <mailto:drill-user-unsubscribe@incubator.apache.org>
List-Post: <mailto:drill-user@incubator.apache.org>
List-Id: <drill-user.incubator.apache.org>
Reply-To: drill-user@incubator.apache.org
Delivered-To: mailing list drill-user@incubator.apache.org
Received: (qmail 85974 invoked by uid 99); 10 Oct 2014 05:20:24 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Oct 2014 05:20:24 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of mufeed.usman@gmail.com
 designates 209.85.218.52 as permitted sender)
Received: from [209.85.218.52] (HELO mail-oi0-f52.google.com) (209.85.218.52)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Oct 2014 05:20:20 +0000
Received: by mail-oi0-f52.google.com with SMTP id a3so5484561oib.39
        for <drill-user@incubator.apache.org>;
 Thu, 09 Oct 2014 22:20:00 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        bh=L7IghVHhmeaYrPMDkbnDTDvOSvdNKpCVUU2enowGUKE=;
        b=hx2FxUaN4PAv1S+hlj4Twq3RFXIZzwYTGy0fpA/XhmIM3NVYCKUPERL7b+8jKWDzqH
         sJ55kUt59BvbMhQADi7KGK8CAhq/SJuMtRzbVlCgeP9wHLCxN/2K/AK0bvdg4gz8j8Oo
         C70Wc/4fniGMxrTB8royoTaVsteK+g0IHEIlFDoRaGJv9MPCbIF71IC1wwsFu8JKGQcL
         4bouQfpCMV6NPYzUypahDYHzAzcgZuYMotjliFEH99yxJyxyr1m/vgff5bTFByZnVlH0
         WTluYYFwJrlTp/1Zgeyw/cEeZucSPTMU5FXvvnkuXjAtCU41hpZrco9O7vrkqsOAHDbC
         B6mA==
MIME-Version: 1.0
X-Received: by 10.202.59.11 with SMTP id i11mr2202457oia.17.1412918400141;
 Thu, 09 Oct 2014 22:20:00 -0700 (PDT)
Received: by 10.60.134.231 with HTTP; Thu, 9 Oct 2014 22:20:00 -0700 (PDT)
In-Reply-To: 
 <CA+eYymEAMCue1hswcdx_U1fWMRtYwkMf+n7oK7fKh2guQDM7nw@mail.gmail.com>
References: 
 <CA+eYymFP0s5pnX-waMWpBFqoP=G=4Z2GnnA4Q_66G78kGEt4aA@mail.gmail.com>
	<5434295A.9000808@gmail.com>
	<CA+eYymEAMCue1hswcdx_U1fWMRtYwkMf+n7oK7fKh2guQDM7nw@mail.gmail.com>
Date: Fri, 10 Oct 2014 10:50:00 +0530
Message-ID: 
 <CA+eYymEoTDJGB=QmgfgfS3JsMV9LBbc95MU5+aA7mKRk0CQg2g@mail.gmail.com>
Subject: Re: Query Storage Plug-ins From sqlline
From: mufy <mufeed.usman@gmail.com>
To: "drill-user@incubator.apache.org" <drill-user@incubator.apache.org>
Content-Type: multipart/alternative; boundary=001a113cfb2856503c05050ab300
X-Virus-Checked: Checked by ClamAV on apache.org

--001a113cfb2856503c05050ab300
Content-Type: text/plain; charset=UTF-8

So once I know my storage plugin like,

0: jdbc:drill:zk=n67:5181> select * from INFORMATION_SCHEMA.SCHEMATA where
SCHEMA_NAME like 'json%';
+--------------+-------------+--------------+------------+------------+
| CATALOG_NAME | SCHEMA_NAME | SCHEMA_OWNER |    TYPE    | IS_MUTABLE |
+--------------+-------------+--------------+------------+------------+
| DRILL        | json.default | <owner>      | file       | NO         |
| DRILL        | json.root   | <owner>      | file       | NO         |
+--------------+-------------+--------------+------------+------------+

How do I get the details within each of those from sqlline itself?


---
Mufeed Usman
My LinkedIn <http://www.linkedin.com/pub/mufeed-usman/28/254/400> | My
Social Cause <http://www.vision2016.org.in/> | My Blogs : LiveJournal
<http://mufeed.livejournal.com>




On Wed, Oct 8, 2014 at 10:12 AM, mufy <mufeed.usman@gmail.com> wrote:

> Thank you Mehant.
>
>
> ---
> Mufeed Usman
> My LinkedIn <http://www.linkedin.com/pub/mufeed-usman/28/254/400> | My
> Social Cause <http://www.vision2016.org.in/> | My Blogs : LiveJournal
> <http://mufeed.livejournal.com>
>
>
>
>
> On Tue, Oct 7, 2014 at 11:26 PM, Mehant Baid <baid.mehant@gmail.com>
> wrote:
>
>> You can view all the storage plugins that are currently enabled using the
>> following query
>> select * from INFORMATION_SCHEMA.SCHEMATA;
>>
>> Thanks
>> Mehant
>>
>> On 10/7/14, 2:29 AM, mufy wrote:
>>
>>> How do I query my storage plugins from the sqlline? To see what is
>>> configured and not?
>>>
>>> ---
>>> Mufeed Usman
>>> My LinkedIn <http://www.linkedin.com/pub/mufeed-usman/28/254/400> | My
>>> Social Cause <http://www.vision2016.org.in/> | My Blogs : LiveJournal
>>> <http://mufeed.livejournal.com>
>>>
>>>
>>
>

--001a113cfb2856503c05050ab300--