All Configurations

The following table describes all Generic and Administration configuration flags:

Flag Name	Access Control	Modification Type	Description
binSizes	Admin	Regular	Sets the custom bin size in the cache to enable high granularity bin control.
cacheDiskDir	Generic	Regular	Sets the ondisk directory location for the spool to save files on.
cacheDiskGB	Generic	Regular	Sets the amount of memory (GB) to be used by Spool on the disk.
cacheEvictionMilliseconds	Generic	Regular	Sets how long the cache stores contents before being flushed.
cachePartitions	Generic	Regular	Sets the number of partitions that the cache is split into.
cachePersistentDir	Generic	Regular	Sets the persistent directory location for the spool to save files on.
cachePersistentGB	Generic	Regular	Sets the amount of data (GB) for the cache to store persistently.
cacheRamGB	Generic	Regular	Sets the amount of memory (GB) to be used by Spool InMemory.
checkCudaMemory	Admin	Regular	Sets the pad device memory allocations with safety buffers to catch out-of-bounds writes.
compilerGetsOnlyUFs	Admin	Regular	Sets the runtime to pass only utility functions names to the compiler.
copyToRestrictUtf8	Admin	Regular	Sets the custom bin size in the cache to enable high granularity bin control.
cpuReduceHashtableSize	Admin	Regular	Sets the hash table size of the CpuReduce.
csvLimitRowLength	Admin	Cluster	Sets the maximum supported CSV row length.
cudaMemcpyMaxSizeBytes	Admin	Regular	Sets the chunk size for copying from CPU to GPU. If set to 0, do not divide.
CudaMemcpySynchronous	Admin	Regular	Indicates if copying from/to GPU is synchronous.
cudaMemQuota	Admin	Worker	Sets the percentage of total device memory to be used by the instance.
developerMode	Admin	Regular	Enables modifying R&D flags.
enableDeviceDebugMessages	Admin	Regular	Activates the Nvidia profiler (nvprof) markers.
enableLogDebug	Admin	Regular	Enables creating and logging in the clientLogger_debug file.
enableNvprofMarkers	Admin	Regular	Activates the Nvidia profiler (nvprof) markers.
endLogMessage	Admin	Regular	Appends a string at the end of every log line.
extentStorageFileSizeMB	Admin	Cluster	Sets the minimum size in mebibytes of extents for table bulk data.
flipJoinOrder	Generic	Regular	Reorders join to force equijoins and/or equijoins sorted by table size.
gatherMemStat	Admin	Regular	Monitors all pinned allocations and all memcopies to/from device, and prints a report of pinned allocations that were not memcopied to/from the device using the dump_pinned_misses utility function.
increaseChunkSizeBeforeReduce	Admin	Regular	Increases the chunk size to reduce query speed.
increaseMemFactors	Admin	Regular	Adds rechunker before expensive chunk producer.
leveldbWriteBufferSize	Admin	Regular	Sets the buffer size.
limitQueryMemoryGB	Generic	Worker	Prevents a query from processing more memory than the flag’s value.
logSysLevel	Generic	Regular	Determines the client log level: 0 - L_SYSTEM, 1 - L_FATAL, 2 - L_ERROR, 3 - L_WARN, 4 - L_INFO, 5 - L_DEBUG, 6 - L_TRACE
machineIP	Admin	Worker	Manual setting of reported IP.
maxAvgBlobSizeToCompressOnGpu	Generic	Regular	Sets the CPU to compress columns with size above (flag’s value) * (row count).
memoryResetTriggerMB	Admin	Regular	Sets the size of memory used during a query to trigger aborting the server.
metadataServerPort	Admin	Worker	Sets the port used to connect to the metadata server. SQream recommends using port ranges above 1024† because ports below 1024 are usually reserved, although there are no strict limitations. Any positive number (1 - 65535) can be used.
mtRead	Admin	Regular	Splits large reads to multiple smaller ones and executes them concurrently.
mtReadWorkers	Admin	Regular	Sets the number of workers to handle smaller concurrent reads.
orcImplicitCasts	Admin	Regular	Sets the implicit cast in orc files, such as int to tinyint and vice versa.
sessionTag	Generic	Regular	Sets the name of the session tag.
spoolMemoryGB	Generic	Regular	Sets the amount of memory (GB) to be used by the server for spooling.
statementLockTimeout	Admin	Regular	Sets the timeout (seconds) for acquiring object locks before executing statements.
useConfigIP	Admin	Worker	Activates the machineIP (true). Setting to false ignores the machineIP and automatically assigns a local network IP. This cannot be activated in a cloud scenario (on-premises only).
useLegacyDecimalLiterals	Admin	Regular	Interprets decimal literals as Double instead of Numeric. Used to preserve legacy behavior in existing customers.
useLegacyStringLiterals	Admin	Regular	Interprets ASCII-only strings as VARCHAR instead of TEXT. Used to preserve legacy behavior in existing customers.
varcharIdentifiers	Admin	Regular	Activates using varchar as an identifier.