Configure a resource-based service: HadoopSQL
How to add a HadoopSQL service.
-
On Service Manager > Resource Policies, click Add New Service (
) next to HadoopSQL.
Create Service appears.
-
On Create Service, enter the following information:
Table 1. Service Details Field name
Description
Service Name
The name of the service; required when configuring agents.
Display Name The name which will appear on Service Manager. Description
A description of the service.
Active Status
Enabled or Disabled.
Tag Service Select a tag-based service to apply the service and its tag-based policies to Hive. Table 2. Configuration Properties Field name
Description
Username
The end system username that can be used for connection.
Password
The password for the username entered above.
jdbc.driver ClassName
The full classname of the driver used for Hive connections. Default: org.apache.hive.jdbc.HiveDriver
jdbc.url
The complete connection URL, including port and database name. (Default port: 10000.) For example, on the sandbox, jdbc:hive2://sandbox:10000/.
Common Name For Certificate
The name of the certificate.
This field is interchangeably named Common Name For Certificate and Ranger Plugin SSL CName in Create Service pages.
Policy Download Users Selected users can download policies in the service. Tag Download Users Selected users can download tags in the service. Service Admin Users Selected users can create/update/delete/read policies in the service. Service Admin Groups Users in the selected groups can create/update/delete/read policies in the service. Superusers The plugin grants all accesses on all resources to the selected users. Superuser Groups The plugin grants all accesses on all resources to users in the selected groups. Userstore Download Users Selected users can download user and group details. Add New Configurations
Add any other new configuration(s).
- Click Test Connection.
- Click Add.
