The error callstack pasted is generic. If debug not enabled, can you enable debug logs and run the query again to see if there are any other warnings or debug messages?
In any case, please log a bug with repro steps and also config changes made (both in drill-override.conf and drill-env.sh) Thanks Venki On Sat, Aug 29, 2015 at 8:40 AM, Sungwook Yoon <[email protected]> wrote: > 'uuu' can hadoop cat on that view file. > > and here is the log, of the error, > > 2015-08-29 11:38:07,528 [Client-1] INFO > o.a.d.j.i.DrillResultSetImpl$ResultsListener - [#3] Query failed: > org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: From > line 1, column 15 to line 1, column 23: Table 'vvv' not found > > > [Error Id: 4515ada9-d346-46d6-a9be-d1df200abf72 on > ip-172-31-20-12.ec2.internal:31010] > at > > org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:118) > [drill-java-exec-1.1.0.jar:1.1.0] > at > > org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:111) > [drill-java-exec-1.1.0.jar:1.1.0] > at > > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:47) > [drill-java-exec-1.1.0.jar:1.1.0] > at > > org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:32) > [drill-java-exec-1.1.0.jar:1.1.0] > at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:61) > [drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:233) > [drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:205) > [drill-java-exec-1.1.0.jar:1.1.0] > at > > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254) > [netty-handler-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242) > [netty-codec-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847) > [netty-transport-4.0.27.Final.jar:4.0.27.Final] > at > > io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:618) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at > io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:329) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at > io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:250) > [netty-transport-native-epoll-4.0.27.Final-linux-x86_64.jar:na] > at > > io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111) > [netty-common-4.0.27.Final.jar:4.0.27.Final] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_85] > > > On Sat, Aug 29, 2015 at 10:22 AM, Venki Korukanti < > [email protected] > > wrote: > > > 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 > > > > > >
