So, for the same view, if I change the owner, then it works. BUT, adding group, or changing group does NOT work.
Sungwook On Sat, Aug 29, 2015 at 11:14 AM, Sungwook Yoon <[email protected]> wrote: > > I tracked to the foreman, this log may give you a better idea? > > [Error Id: edbf878d-e96d-4997-b498-1714cac21fa0 ] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:523) > ~[drill-common-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:181) > [drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:903) > [drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:242) > [drill-java-exec-1.1.0.jar:1.1.0] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_85] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_85] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_85] > Caused by: org.apache.calcite.tools.ValidationException: > org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 > to line 1, column 23: Table 'mktscan_d' not found > at > org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:176) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.prepare.PlannerImpl.validateAndGetType(PlannerImpl.java:185) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:428) > ~[drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:188) > ~[drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:157) > ~[drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:178) > [drill-java-exec-1.1.0.jar:1.1.0] > ... 5 common frames omitted > Caused by: org.apache.calcite.runtime.CalciteContextException: From line > 1, column 15 to line 1, column 23: Table 'mktscan_d' not found > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) ~[na:1.7.0_85] > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > ~[na:1.7.0_85] > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[na:1.7.0_85] > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > ~[na:1.7.0_85] > at > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:689) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:674) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3750) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:106) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:837) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:552) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:174) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > ... 10 common frames omitted > Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Table > 'mktscan_d' not found > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) ~[na:1.7.0_85] > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > ~[na:1.7.0_85] > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[na:1.7.0_85] > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > ~[na:1.7.0_85] > at > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:457) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > ... 28 common frames omitted > 2015-08-29 10:55:11,519 [2a1e3830-578c-d872-c75d-66027e9ab7ee:foreman] > INFO o.a.drill.exec.work.foreman.Foreman - State change requested. > PENDING --> FAILED > org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception > during fragment initialization: PARSE ERROR: From line 1, column 15 to line > 1, column 23: Table 'mktscan_d' not found > > > [Error Id: edbf878d-e96d-4997-b498-1714cac21fa0 ] > at > org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:253) > [drill-java-exec-1.1.0.jar:1.1.0] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [na:1.7.0_85] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [na:1.7.0_85] > at java.lang.Thread.run(Thread.java:745) [na:1.7.0_85] > Caused by: org.apache.drill.common.exceptions.UserException: PARSE ERROR: > From line 1, column 15 to line 1, column 23: Table 'mktscan_d' not found > > > [Error Id: edbf878d-e96d-4997-b498-1714cac21fa0 ] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:523) > ~[drill-common-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:181) > ~[drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:903) > [drill-java-exec-1.1.0.jar:1.1.0] > ... 3 common frames omitted > Caused by: org.apache.calcite.tools.ValidationException: > org.apache.calcite.runtime.CalciteContextException: From line 1, column 15 > to line 1, column 23: Table 'mktscan_d' not found > at > org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:176) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.prepare.PlannerImpl.validateAndGetType(PlannerImpl.java:185) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:428) > ~[drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:188) > ~[drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:157) > ~[drill-java-exec-1.1.0.jar:1.1.0] > at > org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:178) > ~[drill-java-exec-1.1.0.jar:1.1.0] > ... 5 common frames omitted > Caused by: org.apache.calcite.runtime.CalciteContextException: From line > 1, column 15 to line 1, column 23: Table 'mktscan_d' not found > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) ~[na:1.7.0_85] > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > ~[na:1.7.0_85] > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[na:1.7.0_85] > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > ~[na:1.7.0_85] > at > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:689) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:674) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3750) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:106) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > -drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:837) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:552) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:174) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > ... 10 common frames omitted > Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Table > 'vvv' not found > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > Method) ~[na:1.7.0_85] > at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > ~[na:1.7.0_85] > at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > ~[na:1.7.0_85] > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > ~[na:1.7.0_85] > at > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > at > org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:457) > ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > ... 28 common frames omitted > 2015-08-29 10:55:11,523 [2a1e3830-578c-d872-c75d-66027e9ab7ee:foreman] > INFO o.a.drill.exec.work.foreman.Foreman - foreman cleaning up. > > > > On Sat, Aug 29, 2015 at 11:03 AM, Sungwook Yoon <[email protected]> > wrote: > >> >> 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 >>> > > > >>> > > >>> > >>> >> >> >
