Specifies the maximum number of records per page the provider returns when requesting data from Apache Hive.

Syntax

Connect-ApacheHive -Pagesize int

Data Type

int

Default Value

10000

Remarks

When processing a query, instead of requesting all of the queried data at once from Apache Hive, the cmdlet can request the queried data in pieces called pages.

This connection property determines the maximum number of results that the cmdlet requests per page.

Note: Setting large page sizes may improve overall query execution time, but doing so causes the cmdlet to use more memory when executing queries and risks triggering a timeout.