Can you check the logs to see if there are any permission errors? Also is the user 'uuu' has access to read the directory where the view is present?
You can also try login to shell as user 'uuu' and 'hadoop cat' to read the view file. If the 'hadoop cat' succeeds here, Drill should be able to read the view file as user 'uuu'. thanks Venki On Sat, Aug 29, 2015 at 8:15 AM, Sungwook Yoon <[email protected]> wrote: > Hi, > > Drill 1.1.0 > > I created a view 'vvv' and changed group of it to group 'ggg'; > > Then, I ran sqlline as another user 'uuu'; > 'uuu' belongs to group 'ggg' > > When 'uuu' tried to read 'vvv', it fails with following error, > > Error: PARSE ERROR: From line 1, column 15 to line 1, column 23: Table > 'vvv' not found > > > [Error Id: c3fc9f5b-77ec-4e98-9641-a9876d389fa7 on > ip-172-31-20-12.ec2.internal:31010] (state=,code=0) > > 'vvv.view.drill has read permission on group 'ggg'. > > Where am I going wrong here? > > Thanks, > > Sungwook >
