[DRILL-5426] Queries fail with "RESOURCE ERROR: Failed to create schema tree." when Impersonation is enabled

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.9.0, 1.10.0, 1.11.0
• Component/s: Client - CLI, Client - HTTP, Client - JDBC, Tools, Build & Test
• Labels: impersonation usability

Environment

DFS connected to MapR FileSystem

• Assignee: Unassigned
• Reporter: Abhishek Girish
• Created: 10/Apr/17 18:58
• Updated: 10/Apr/17 18:58

Description

When Drillbit impersonation is enabled and clients connect without specifying the username (and password), queries fails to execute:

# $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.

The error disappears when username is specified:

# $DRILL_HOME/bin/sqlline -u "jdbc:drill:zk=localhost:5181" -n root -p root
sqlline> select * from sys.drillbits;
SUCCESS

Log attached.