Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5426

Queries fail with "RESOURCE ERROR: Failed to create schema tree." when Impersonation is enabled

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    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.

      Attachments

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            agirish Abhishek Girish
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment