Setting up Ranger to run SQL queries

As administrator, you set up authorization in Ranger for users to connect to Hive or Impala, and run queries.

  • You obtained the administrator role that allows you to set up Ranger policies.
  • You logged into CDP One, and accepted the default or selected another environment.
  1. In Security, click Manage Policies.
    The Ranger Service Manager appears:
  2. Click Hadoop SQL.
  3. In Hadoop SQL Policies, in Allow Conditions, edit the all - database, table, column.
  4. In Select User, in All permissions, select your user name.
  5. Click Save.