Modify the Hive Storage Plugin in Drill
About this task
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:
Procedure
-
Navigate to
http://<drillbit_hostname>:8047
, and select the Storage tab.WARNING: You can only access the Drill Web UI for a running Drillbit. - Click Update next to the hive option.
-
In the configuration window, add the
hive.metastore.sasl.enabled
,hive.metastore.kerberos.principal
, andhive.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>" } }