Adding Query Processor Administrator users on Data Hub clusters

Query Store Administrators have special privileges that enable them to view and monitor queries from all users, including the ones that were submitted from query interfaces, such as Beeline, Hive Warehouse Connector (HWC), Tableau, and so on.

  1. Log in to Cloudera Manager as an Administrator.
  2. Go to Clusters > Query Processor > Configuration and enter the list of users in the Extra Auth Options field as follows:
    "adminUsers": "hive, [***USER-1***], [***USER-2***]"
    You can also add a list of admin groups as follows:
    "adminGroups": "admin-group, [***GROUP-1***], [***GROUP-2***]"
  3. Click Save Changes.
  4. Restart the Query Processor service.