You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by mufy <mu...@gmail.com> on 2014/10/07 11:29:43 UTC
Query Storage Plug-ins From sqlline
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>
Re: Query Storage Plug-ins From sqlline
Posted by Aditya <ad...@gmail.com>.
Try this:
curl http://<*drill_bit_host*>:8047/storage/<plugin_name>.json
On Thu, Oct 9, 2014 at 10:37 PM, mufy <mu...@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 <ad...@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 <mu...@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 <mu...@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 <ba...@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>
>> > >>>
>> > >>>
>> > >>
>> > >
>> >
>>
>
>
Re: Query Storage Plug-ins From sqlline
Posted by mufy <mu...@gmail.com>.
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 <ad...@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 <mu...@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 <mu...@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 <ba...@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>
> > >>>
> > >>>
> > >>
> > >
> >
>
Re: Query Storage Plug-ins From sqlline
Posted by Aditya <ad...@gmail.com>.
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 <mu...@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 <mu...@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 <ba...@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>
> >>>
> >>>
> >>
> >
>
Re: Query Storage Plug-ins From sqlline
Posted by mufy <mu...@gmail.com>.
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 <mu...@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 <ba...@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>
>>>
>>>
>>
>
Re: Query Storage Plug-ins From sqlline
Posted by mufy <mu...@gmail.com>.
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 <ba...@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>
>>
>>
>
Re: Query Storage Plug-ins From sqlline
Posted by Mehant Baid <ba...@gmail.com>.
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>
>