drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aditya <adityakish...@gmail.com>
Subject Re: Query Storage Plug-ins From sqlline
Date Fri, 10 Oct 2014 05:31:00 GMT
I don't think you can do that from sqlline currently.

However, if you want to access the details from command line, you can use
the REST APIs.

Please see this for more information
https://docs.google.com/document/d/1mRsuWk4Dpt6ts-jQ6ke3bB30PIwanRiCPfGxRwZEQME/edit#heading=h.lrzkwkxqipiv


On Thu, Oct 9, 2014 at 10:20 PM, mufy <mufeed.usman@gmail.com> wrote:

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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message