ALTER TABLE statement contains a lot of operations. it can be
altering table's metadata or altering table's data, or create new
partitions etc. So ALTER TABLE should not all have the identical
privilege control.
Each alter table operation has its own name internally in hive, so
they can have more f
Thanks a lot for the response, Yongqiang! Just a thought, inline.
On Tue, Mar 22, 2011 at 7:28 PM, yongqiang he wrote:
> >>INDEX - my best guess is that this allows me to create/drop indexes on a
> table?
> Yes. It is there for this purpose.
>
> >> Is it the case that if I have select access on
>>INDEX - my best guess is that this allows me to create/drop indexes on a
table?
Yes. It is there for this purpose.
>> Is it the case that if I have select access on a table, I can use
any index that exists on a table?
No. index is also a table now, so you need to have access to both of them.
>>
Hi all,
I'm trying to understand the meaning of some of the privileges in the
system, and I'm a bit stumped on what some of them actually do.
Privileges that confuse me:
INDEX - my best guess is that this allows me to create/drop indexes on a
table? Is it the case that if I have select access on