I enabled foreman debug in logback.xml
What else should I enable?
The only I change made to drill-override.conf are following lines,
drill.exec.impersonation: {
enabled: true,
max_chained_user_hops: 3
}
And, these are my drill-env.
DRILL_MAX_DIRECT_MEMORY="8G"
DRILL_HEAP="4G"
export DRILL_JAVA_OPTS="-Xms$DRILL_HEAP -Xmx$DRILL_HEAP
-XX:MaxDirectMemorySize=$DRILL_MAX_DIRECT_MEMORY -XX:MaxPermSize=512M
-XX:ReservedCodeCacheSize=1G -Ddrill.exec.enable-epoll=true"
# Class unloading is disabled by default in Java 7
#
http://hg.openjdk.java.net/jdk7u/jdk7u60/hotspot/file/tip/src/share/vm/runtime/globals.hpp#l1622
export SERVER_GC_OPTS="-XX:+CMSClassUnloadingEnabled -XX:+UseG1GC "
export DRILL_JAVA_OPTS="$DRILL_JAVA_OPTS
-Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf
-Dzookeeper.sasl.client=false "
export DRILL_LOG_DIR="/opt/mapr/drill/drill-1.1.0/logs"
export MAPR_IMPERSONATION_ENABLED=true
export MAPR_TICKETFILE_LOCATION=/opt/mapr/conf/mapruserticket
export HADOOP_HOME=/opt/mapr/hadoop/hadoop-2.7.0
Sungwook
On Sat, Aug 29, 2015 at 10:55 AM, Venki Korukanti <[email protected]
> wrote:
> 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
> > > >
> > >
> >
>
