Re: Securing Hive inserts

2016-04-15 Thread Colm O hEigeartaigh
r.apache.org>, "cohei...@apache.org" < > cohei...@apache.org> > Date: Friday, April 15, 2016 at 9:59 AM > To: Balaji Ganesan > Cc: "user@ranger.incubator.apache.org" > Subject: Re: Securing Hive inserts > > Hi Balaji, > > I have a trivial tabl

Re: Securing Hive inserts

2016-04-15 Thread Selvamohan Neethiraj
, Selva- From: Colm O hEigeartaigh Reply-To: "user@ranger.incubator.apache.org" , "cohei...@apache.org" Date: Friday, April 15, 2016 at 9:59 AM To: Balaji Ganesan Cc: "user@ranger.incubator.apache.org" Subject: Re: Securing Hive inserts Hi Balaji, I have a trivi

Re: Securing Hive inserts

2016-04-15 Thread Colm O hEigeartaigh
Hi Balaji, I have a trivial table containing the output of the canonical "WordCount" program on a text file. The table just contains two columns, one containing the word and the other the count. The following query fails with the error message above: insert into words (word, count) values ('xyz',

Re: Securing Hive inserts

2016-04-14 Thread Balaji Ganesan
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 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,

Securing Hive inserts

2016-04-14 Thread Colm O hEigeartaigh
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 d