Oracle Cloud Infrastructure Documentation

Advanced Ranger Configurations

For Big Data Service clusters, the property ranger.db.maxrows.default in Apache Ranger controls the default maximum number of rows that are returned when retrieving data from the Ranger database.

This property is used to limit the size of query results to prevent excessively large responses. To configure ranger.db.maxrows.default, complete the following:

  1. Access Apache Ambari.
  2. From the side toolbar, under Services select Ranger.
  3. Select the Configs tab, and then select Advanced.
  4. Update the ranger.db.maxrows.default property. For example, set the value to 500.
  5. Select Add to save the update.
  6. Save the changes.
  7. Select Restart and select Restart all affected. Select Confirm restart all.