drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mufy <mufeed.us...@gmail.com>
Subject Re: Query Storage Plug-ins From sqlline
Date Fri, 10 Oct 2014 05:37:27 GMT
Thank you Aditya. I'm not familiar with REST APIs apart from seeing it
flying around in the forum :-). But will definitely try and see what I can
learn from what you've sent.

Appreciate it.


---
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 Fri, Oct 10, 2014 at 11:01 AM, Aditya <adityakishore@gmail.com> wrote:

> 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