You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Sungwook Yoon <sy...@maprtech.com> on 2015/08/29 17:15:02 UTC
impersonation question
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
Re: impersonation question
Posted by Venki Korukanti <ve...@gmail.com>.
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 <sy...@maprtech.com> 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 <sy...@maprtech.com>
> 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 <sy...@maprtech.com>
> > 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 <
> >> venki.korukanti@gmail.com> 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 <sy...@maprtech.com>
> >>> 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 <
> >>> > venki.korukanti@gmail.com
> >>> > > 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 <syoon@maprtech.com
> >
> >>> > 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
> >>> > > >
> >>> > >
> >>> >
> >>>
> >>
> >>
> >
>
Re: impersonation question
Posted by Sungwook Yoon <sy...@maprtech.com>.
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 <sy...@maprtech.com> 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 <sy...@maprtech.com>
> 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 <
>> venki.korukanti@gmail.com> 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 <sy...@maprtech.com>
>>> 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 <
>>> > venki.korukanti@gmail.com
>>> > > 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 <sy...@maprtech.com>
>>> > 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
>>> > > >
>>> > >
>>> >
>>>
>>
>>
>
Re: impersonation question
Posted by Sungwook Yoon <sy...@maprtech.com>.
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 <sy...@maprtech.com> 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 <
> venki.korukanti@gmail.com> 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 <sy...@maprtech.com>
>> 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 <
>> > venki.korukanti@gmail.com
>> > > 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 <sy...@maprtech.com>
>> > 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
>> > > >
>> > >
>> >
>>
>
>
Re: impersonation question
Posted by Sungwook Yoon <sy...@maprtech.com>.
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 <venki.korukanti@gmail.com
> 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 <sy...@maprtech.com> 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 <
> > venki.korukanti@gmail.com
> > > 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 <sy...@maprtech.com>
> > 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
> > > >
> > >
> >
>
Re: impersonation question
Posted by Venki Korukanti <ve...@gmail.com>.
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 <sy...@maprtech.com> 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 <
> venki.korukanti@gmail.com
> > 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 <sy...@maprtech.com>
> 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
> > >
> >
>
Re: impersonation question
Posted by Sungwook Yoon <sy...@maprtech.com>.
'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 <venki.korukanti@gmail.com
> 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 <sy...@maprtech.com> 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
> >
>
Re: impersonation question
Posted by Venki Korukanti <ve...@gmail.com>.
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 <sy...@maprtech.com> 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
>