System Administration
Loading Administration
Alter Default Data Pipeline Behavior
an administrator might configure some parameters that control the behavior of data pipelines to modify the default behavior across the {{ocient}} system or specific nodes you can use the alter system alter config sql statements to control the configuration parameters syntax alter system alter config set 'sql pipelineparameters parameter name' 'parameter value'; parameter data type description parameter name string the name of the pipeline parameter, either general or specific to the binary format parameter value string the value for the pipeline parameter general parameters general parameter name default data type required value and description sql pipelineparameters targettimeperextractortask 600 uint64 t target execution time in seconds for run extractor tasks for file loads sql pipelineparameters defaultpartitionsperextractortask 1 int number of partitions per task if you set this parameter to 1, the number is based on available cpu cores sql pipelineparameters defaultextractorcores 1 int number of cores to use in a task if you set this parameter to 1, the number is based on available cpu cores binary format parameters you can modify these parameters to change the default behavior of the binary data format extraction binary format parameter name default data type required value and description sql pipelineparameters extract binary defaultendianness big string the endianness of transforms when you do not specify it in another way supported values are big or little sql pipelineparameters extract binary defaultcharset ibm1047 string determines the default character set to use when you load data in the binary format sql pipelineparameters extract binary defaultautotrimpadding true boolean determines the default for whether a padding character should be trimmed when decoding data in the binary format to a string sql pipelineparameters extract binary defaultpaddingcharacter ' ' char determines the default padding character to trim from the end of a string when decoding data in the binary format this parameter is effective only if the extract binary defaultautotrimpadding parameter is set to true examples set the target execution time for the extractor task to 600 seconds alter system alter config set 'sql pipelineparameters targettimeperextractortask' 600; set the default endianness of transforms to little endian for the binary extract alter system alter config set 'sql pipelineparameters extract binary defaultendianness' 'little'; the configuration values only go into effect after the alter sql statement succeeds and you restart the affected nodes related links docid\ xq0tg7yph vn62uwufibu docid 7s5nztl8lolpwt2pcnjyz docid 1 jhzrhblgnqucl6skiaq docid\ xq349m9w7wzqtvo v9k9v