Downloading more than 10000 Rows of Navigator Audit data in JSON format

0 votes
4 views
asked Aug 30, 2017 in Hadoop by admin (4,410 points)
SummaryWhen using Cloudera Navigator API to download the audit data in JSON format, it can only download 10000 rows maximum even if changing the API call limit parameter to more than 10000.

Symptoms
Applies To
  • Navigator Audit
  • API
Cause

Navigator limit parameter is fixed to 10000 by default.

Instructions

With the API you can use the offset and re-request to get more rows. For example, for 30000 rows, three consecutive requests can be made:

offset=0, limit=10000
offset=10000, limit=10000
offset=20000, limit=10000

Example:

  1. http://<navigator-metadata-server>:7187/api/v9/audits/?query=****&offset=0&limit=10000&format=JSON​
  2. http://<navigator-metadata-server>:7187/api/v9/audits/?query=****&offset=10000&limit=10000&format=JSON
  3. http://<navigator-metadata-server>:7187/api/v9/audits/?query=****&offset=20000&limit=10000&format=JSON​

Please log in or register to answer this question.

...