BATCH_SIZE Query Option
Number of rows evaluated at a time by SQL operators. Unspecified or a size of 0 uses a predefined default size. Using a large number improves responsiveness, especially for scan operations, at the cost of a higher memory footprint.
This option is primarily for Cloudera testing, or for use under the direction of Cloudera Support.
Default: 0 (meaning the predefined default of 1024)
|<< APPX_COUNT_DISTINCT Query Option (CDH 5.2 or higher only)||©2016 Cloudera, Inc. All rights reserved||COMPRESSION_CODEC Query Option (CDH 5.2 or higher only) >>|