[ https://issues.apache.org/jira/browse/DRILL-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sorabh Hamirwasia reopened DRILL-5704: -------------------------------------- > Improve error message on client side when queries fail with "Failed to create > schema tree." when Impersonation is enabled and logins are anonymous > -------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DRILL-5704 > URL: https://issues.apache.org/jira/browse/DRILL-5704 > Project: Apache Drill > Issue Type: Improvement > Reporter: Sorabh Hamirwasia > Assignee: Sorabh Hamirwasia > Labels: ready-to-commit > Fix For: 1.12.0 > > > Reported by [~agirish] > When username is not specified then Drill set's the session user as anonymous > if impersonation is enabled. During query execution Drill tries to build > schema tree and as part of that it validates if the user has access to the > workspace or not by using FileClient Api liststatus which verifies the user > from the OS user. Since impersonation is only enabled here without > authentication and we don't specify any user in connection string, Drill will > use default user which is "anonymous" and pass that to check workspace > permission which will fail as node doesn't have any valid user with that name. > {code:java} > Caused by: java.io.IOException: Error getting user info for current user, > anonymous > ...... > ...... > at > org.apache.drill.exec.store.dfs.DrillFileSystem.listStatus(DrillFileSystem.java:523) > ~[drill-java-exec-1.9.0-SNAPSHOT.jar:1.9.0-SNAPSHOT] > at > org.apache.drill.exec.store.dfs.WorkspaceSchemaFactory.accessible(WorkspaceSchemaFactory.java:157) > ~[drill-java-exec-1.9.0-SNAPSHOT.jar:1.9.0-SNAPSHOT] > at > org.apache.drill.exec.store.dfs.FileSystemSchemaFactory$FileSystemSchema.<init>(FileSystemSchemaFactory.java:78) > ~[drill-java-exec-1.9.0-SNAPSHOT.jar:1.9.0-SNAPSHOT] > at > org.apache.drill.exec.store.dfs.FileSystemSchemaFactory.registerSchemas(FileSystemSchemaFactory.java:65) > ~[drill-java-exec-1.9.0-SNAPSHOT.jar:1.9.0-SNAPSHOT] > at > org.apache.drill.exec.store.dfs.FileSystemPlugin.registerSchemas(FileSystemPlugin.java:150) > ~[drill-java-exec-1.9.0-SNAPSHOT.jar:1.9.0-SNAPSHOT] > at > org.apache.drill.exec.store.StoragePluginRegistryImpl$DrillSchemaFactory.registerSchemas(StoragePluginRegistryImpl.java:365) > ~[drill-java-exec-1.9.0-SNAPSHOT.jar:1.9.0-SNAPSHOT] > at > org.apache.drill.exec.store.SchemaTreeProvider.createRootSchema(SchemaTreeProvider.java:72) > [drill-java-exec-1.9.0-SNAPSHOT.jar:1.9.0-SNAPSHOT] > ... 10 common frames omitted > {code} > # $DRILL_HOME/bin/sqlline -u "jdbc:drill:zk=localhost:5181" > sqlline> select * from sys.drillbits; > User Error Occurred > org.apache.drill.common.exceptions.UserException: RESOURCE ERROR: Failed to > create schema tree. -- This message was sent by Atlassian JIRA (v6.4.14#64029)