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:20:00 GMT
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