Cloudera Docs

Changing the number of rows downloaded to CSV

At the visual level, you can control how many rows are included when you download data to a CSV file or view detailed data by using the Number of rows downloaded during CSV export and Detailed Data option.

Default behavior

By default, the number of rows downloaded is determined as follows:

  • The Maximum number of rows to fetch option defines the default row limit for downloads.

  • For table visuals only:

    • If a value is set on the Limit shelf, that value is used first.
    • If the Limit shelf is empty, the Maximum number of rows to fetch value is used instead.

Overriding the default download limit

To override the default behavior and define a custom download limit:
  1. Open the visual in Edit mode.
  2. Open the Data menu.
  3. Set a value in the Number of rows downloaded during CSV export and Detailed Data field.

This setting overrides the Maximum number of rows to fetch option. For table visuals, it also overrides the value set on the Limit shelf. The specified value is applied only to CSV exports and the Detailed Data view. It does not affect how many rows are displayed in the visual itself.

Limit CSV download to 10 rows
  1. Set Number of rows downloaded during CSV export and Detailed Data to 10.
  2. Download the visual data as a CSV file.
  3. Open the downloaded file and verify that only 10 rows are included.

If the value is set to -1 (default), all available rows are included in the download.