FlattenRowLimit
The maximum number of rows that can result from a single flattened element.
Data Type
int
Default Value
250000
Remarks
In some cases the FlattenedDocuments DataModel may try to output more rows than intended, either because of the shape of the data or the table identification options. If the number of rows to be generated is large enough this can lead to memory issues as the adapter has to store all the generated rows in memory before returning them.
To avoid this the adapter will check that the number of rows to be output does not exceed this limit (250000 by default). If the adapter would output more rows than this for a single flattened element it will instead fail the query and report an error.