Configuration seems to be right. Not sure what the problem in this case. We have a unittest which tests the similar scenario (access through group permissions) on MiniDFS. Are the user group settings same on all nodes in the cluster? If yes, then this is a bug. Please log one with details of the underlying core version and repro steps.
On Sat, Aug 29, 2015 at 9:20 AM, Sungwook Yoon <[email protected]> wrote: > 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 > >>> > > > > >>> > > > >>> > > >>> > >> > >> > > >
