Value component of a query band specification.
pair_value can be up to 256 VARCHAR UNICODE characters in length.
The number of name=value pairs is limited to the maximum length of the string, which is 2,048 UNICODE characters, including pad characters.
pair_value cannot contain any of the following characters:
- SEMICOLON (;)
- a null
If an APOSTROPHE character is embedded within a pair value, you must type it twice, to escape it. Otherwise, the system interprets it as a pair_name =pair_value string terminator.
If pair_name is BINPACKALGO4PARQUET, which sets the binpacking algorithm to use when reading Parquet files, pair_value must be one of the following values:
| pair_value | Binpacking Algorithm |
|---|---|
| 0 (Default) | Distributes files across AMPs based on rowgroup boundaries (parallel distribution). |
| 1 | Distributes files across AMPs based on file size, balancing load across all AMPs. Can cause skew if there are fewer files than AMPs or if files are of significantly different sizes. |
| 2 | Same as 0. |