You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@impala.apache.org by 吴朱华 <ik...@gmail.com> on 2017/04/06 13:02:21 UTC
Is there any way to retrieve table metadata using select rather than show?
Hi guys:
Currently, we are using "show databases","show tables" or "Describe table"
to retrieve table metadata, but we use such as "select * from metadata" to
retrieve, just like RDBMS did^_^
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by 吴朱华 <ik...@gmail.com>.
Cool, I will check this out when I free^_^
2017-04-07 14:06 GMT+08:00 Alex Behm <al...@cloudera.com>:
> That's a great idea! We have a label for JIRAs suited to newcomers that
> want to experience the contribution process with a simple change.
>
> https://issues.apache.org/jira/browse/IMPALA-5146?jql=
> project%20%3D%20IMPALA%20AND%20labels%20%3D%20newbie
>
> Feel free to reach out if you need help.
>
>
>
> On Thu, Apr 6, 2017 at 9:14 PM, 吴朱华 <ik...@gmail.com> wrote:
>
>> Lars：
>>
>> I have checked the code, the feature may involve some changes on
>> optimizer or analyzer side. It's a big change. I am looking forward to make
>> more minor contribution, just to experience whole process^_^
>>
>> 2017-04-06 21:20 GMT+08:00 Lars Volker <lv...@cloudera.com>:
>>
>>> Adding support to expose the metadata as tables is tracked in
>>> IMPALA-1761 <https://issues.apache.org/jira/browse/IMPALA-1761>. We
>>> would welcome your contribution to this.
>>>
>>> On Thu, Apr 6, 2017 at 3:16 PM, Jeszy <je...@gmail.com> wrote:
>>>
>>>> Hey,
>>>>
>>>> that's not possible from within impala. If you go directly to the
>>>> HMS's backing DB, you can query that.
>>>> What information are you looking for?
>>>>
>>>> Thanks.
>>>>
>>>> On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
>>>> > Hi guys:
>>>> >
>>>> > Currently, we are using "show databases","show tables" or "Describe
>>>> table"
>>>> > to retrieve table metadata, but we use such as "select * from
>>>> metadata" to
>>>> > retrieve, just like RDBMS did^_^
>>>>
>>>
>>>
>>
>
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by Alex Behm <al...@cloudera.com>.
That's a great idea! We have a label for JIRAs suited to newcomers that
want to experience the contribution process with a simple change.
https://issues.apache.org/jira/browse/IMPALA-5146?jql=project%20%3D%20IMPALA%20AND%20labels%20%3D%20newbie
Feel free to reach out if you need help.
On Thu, Apr 6, 2017 at 9:14 PM, 吴朱华 <ik...@gmail.com> wrote:
> Lars：
>
> I have checked the code, the feature may involve some changes on optimizer
> or analyzer side. It's a big change. I am looking forward to make more
> minor contribution, just to experience whole process^_^
>
> 2017-04-06 21:20 GMT+08:00 Lars Volker <lv...@cloudera.com>:
>
>> Adding support to expose the metadata as tables is tracked in IMPALA-1761
>> <https://issues.apache.org/jira/browse/IMPALA-1761>. We would welcome
>> your contribution to this.
>>
>> On Thu, Apr 6, 2017 at 3:16 PM, Jeszy <je...@gmail.com> wrote:
>>
>>> Hey,
>>>
>>> that's not possible from within impala. If you go directly to the
>>> HMS's backing DB, you can query that.
>>> What information are you looking for?
>>>
>>> Thanks.
>>>
>>> On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
>>> > Hi guys:
>>> >
>>> > Currently, we are using "show databases","show tables" or "Describe
>>> table"
>>> > to retrieve table metadata, but we use such as "select * from
>>> metadata" to
>>> > retrieve, just like RDBMS did^_^
>>>
>>
>>
>
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by Alex Behm <al...@cloudera.com>.
That's a great idea! We have a label for JIRAs suited to newcomers that
want to experience the contribution process with a simple change.
https://issues.apache.org/jira/browse/IMPALA-5146?jql=project%20%3D%20IMPALA%20AND%20labels%20%3D%20newbie
Feel free to reach out if you need help.
On Thu, Apr 6, 2017 at 9:14 PM, 吴朱华 <ik...@gmail.com> wrote:
> Lars：
>
> I have checked the code, the feature may involve some changes on optimizer
> or analyzer side. It's a big change. I am looking forward to make more
> minor contribution, just to experience whole process^_^
>
> 2017-04-06 21:20 GMT+08:00 Lars Volker <lv...@cloudera.com>:
>
>> Adding support to expose the metadata as tables is tracked in IMPALA-1761
>> <https://issues.apache.org/jira/browse/IMPALA-1761>. We would welcome
>> your contribution to this.
>>
>> On Thu, Apr 6, 2017 at 3:16 PM, Jeszy <je...@gmail.com> wrote:
>>
>>> Hey,
>>>
>>> that's not possible from within impala. If you go directly to the
>>> HMS's backing DB, you can query that.
>>> What information are you looking for?
>>>
>>> Thanks.
>>>
>>> On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
>>> > Hi guys:
>>> >
>>> > Currently, we are using "show databases","show tables" or "Describe
>>> table"
>>> > to retrieve table metadata, but we use such as "select * from
>>> metadata" to
>>> > retrieve, just like RDBMS did^_^
>>>
>>
>>
>
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by 吴朱华 <ik...@gmail.com>.
Lars：
I have checked the code, the feature may involve some changes on optimizer
or analyzer side. It's a big change. I am looking forward to make more
minor contribution, just to experience whole process^_^
2017-04-06 21:20 GMT+08:00 Lars Volker <lv...@cloudera.com>:
> Adding support to expose the metadata as tables is tracked in IMPALA-1761
> <https://issues.apache.org/jira/browse/IMPALA-1761>. We would welcome
> your contribution to this.
>
> On Thu, Apr 6, 2017 at 3:16 PM, Jeszy <je...@gmail.com> wrote:
>
>> Hey,
>>
>> that's not possible from within impala. If you go directly to the
>> HMS's backing DB, you can query that.
>> What information are you looking for?
>>
>> Thanks.
>>
>> On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
>> > Hi guys:
>> >
>> > Currently, we are using "show databases","show tables" or "Describe
>> table"
>> > to retrieve table metadata, but we use such as "select * from metadata"
>> to
>> > retrieve, just like RDBMS did^_^
>>
>
>
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by 吴朱华 <ik...@gmail.com>.
Lars：
I have checked the code, the feature may involve some changes on optimizer
or analyzer side. It's a big change. I am looking forward to make more
minor contribution, just to experience whole process^_^
2017-04-06 21:20 GMT+08:00 Lars Volker <lv...@cloudera.com>:
> Adding support to expose the metadata as tables is tracked in IMPALA-1761
> <https://issues.apache.org/jira/browse/IMPALA-1761>. We would welcome
> your contribution to this.
>
> On Thu, Apr 6, 2017 at 3:16 PM, Jeszy <je...@gmail.com> wrote:
>
>> Hey,
>>
>> that's not possible from within impala. If you go directly to the
>> HMS's backing DB, you can query that.
>> What information are you looking for?
>>
>> Thanks.
>>
>> On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
>> > Hi guys:
>> >
>> > Currently, we are using "show databases","show tables" or "Describe
>> table"
>> > to retrieve table metadata, but we use such as "select * from metadata"
>> to
>> > retrieve, just like RDBMS did^_^
>>
>
>
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by Lars Volker <lv...@cloudera.com>.
Adding support to expose the metadata as tables is tracked in IMPALA-1761
<https://issues.apache.org/jira/browse/IMPALA-1761>. We would welcome your
contribution to this.
On Thu, Apr 6, 2017 at 3:16 PM, Jeszy <je...@gmail.com> wrote:
> Hey,
>
> that's not possible from within impala. If you go directly to the
> HMS's backing DB, you can query that.
> What information are you looking for?
>
> Thanks.
>
> On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
> > Hi guys:
> >
> > Currently, we are using "show databases","show tables" or "Describe
> table"
> > to retrieve table metadata, but we use such as "select * from metadata"
> to
> > retrieve, just like RDBMS did^_^
>
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by Lars Volker <lv...@cloudera.com>.
Adding support to expose the metadata as tables is tracked in IMPALA-1761
<https://issues.apache.org/jira/browse/IMPALA-1761>. We would welcome your
contribution to this.
On Thu, Apr 6, 2017 at 3:16 PM, Jeszy <je...@gmail.com> wrote:
> Hey,
>
> that's not possible from within impala. If you go directly to the
> HMS's backing DB, you can query that.
> What information are you looking for?
>
> Thanks.
>
> On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
> > Hi guys:
> >
> > Currently, we are using "show databases","show tables" or "Describe
> table"
> > to retrieve table metadata, but we use such as "select * from metadata"
> to
> > retrieve, just like RDBMS did^_^
>
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by Jeszy <je...@gmail.com>.
Hey,
that's not possible from within impala. If you go directly to the
HMS's backing DB, you can query that.
What information are you looking for?
Thanks.
On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
> Hi guys:
>
> Currently, we are using "show databases","show tables" or "Describe table"
> to retrieve table metadata, but we use such as "select * from metadata" to
> retrieve, just like RDBMS did^_^
Re: Is there any way to retrieve table metadata using select rather
than show?
Posted by Jeszy <je...@gmail.com>.
Hey,
that's not possible from within impala. If you go directly to the
HMS's backing DB, you can query that.
What information are you looking for?
Thanks.
On Thu, Apr 6, 2017 at 3:02 PM, 吴朱华 <ik...@gmail.com> wrote:
> Hi guys:
>
> Currently, we are using "show databases","show tables" or "Describe table"
> to retrieve table metadata, but we use such as "select * from metadata" to
> retrieve, just like RDBMS did^_^