Can you provide the full query you are running? What is this table " values__tmp__table__3" ?
On Thu, Apr 14, 2016 at 4:09 PM, Colm O hEigeartaigh <cohei...@apache.org> wrote: > Hi all, > > I have a policy that grants permissions Select + Update to all columns in > a table called "words" in a given database. However, I can't insert into > this table - I get an error: > > H110 Unable to submit statement. Error while compiling statement: FAILED: > HiveAccessControlException Permission denied: user [colm] does not have > [SELECT] privilege on > [default/values__tmp__table__3/tmp_values_col1,tmp_values_col2] > [ERROR_STATUS] > > Only when I change the table in the policy to "*" does it work. Is there > any way around this? I'm using HDP 2.3.2 btw. > > Thanks, > > Colm. > > > -- > Colm O hEigeartaigh > > Talend Community Coder > http://coders.talend.com >
