Modify the Hive Storage Plugin in Drill

Modify the Hive storage plugin configuration in the Drill Web UI based on the authorization and security scenario for the cluster. You can only access the Drill Web UI for a running Drillbit.

Complete the following steps to configure Drill to use Kerberos with Hive Metastore:

  1. Navigate to http://<drillbit_hostname>:8047, and select the Storage tab.
    Warning: You can only access the Drill Web UI for a running Drillbit.
  2. Click Update next to the hive option.
  3. In the configuration window, add the hive.metastore.sasl.enabled, hive.metastore.kerberos.principal, and hive.security.authorization.enabled properties as shown below, if they are not already present - other properties shown may or may not be needed in your environment:
    {
      "type": "hive",
      "enabled": true,
      "configProps": {
        "hive.metastore.uris": "thrift://<metastore_hostname>:9083",
        "fs.default.name": "maprfs:///",
        "hive.server2.enable.doAs": "false",
        "hive.metastore.sasl.enabled": "true",
        "hive.metastore.kerberos.principal": "<metastore_server_principal_name>"
      }
    }