incubator-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:41:11 GMT
Try this:

curl http://<*drill_bit_host*>:8047/storage/<plugin_name>.json

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

> 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