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
>> > > >
>> > >
>> >
>>
>
>
