Re: Is there any way to retrieve table metadata using select rather than show?

[Alex Behm]

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, 吴朱华  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 :
>
>> Adding support to expose the metadata as tables is tracked in IMPALA-1761
>> . We would welcome
>> your contribution to this.
>>
>> On Thu, Apr 6, 2017 at 3:16 PM, Jeszy  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, 吴朱华  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?

[吴朱华]

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 :

> Adding support to expose the metadata as tables is tracked in IMPALA-1761
> . We would welcome
> your contribution to this.
>
> On Thu, Apr 6, 2017 at 3:16 PM, Jeszy  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, 吴朱华  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?

[Lars Volker]

Adding support to expose the metadata as tables is tracked in IMPALA-1761
. We would welcome your
contribution to this.

On Thu, Apr 6, 2017 at 3:16 PM, Jeszy  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, 吴朱华  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?

[Jeszy]

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, 吴朱华  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^_^