Skip to main content

system.settings

Contains information about databend system settings.

Query all settings can use show settings

compression

Format compression. Commonly used in stream load scenarios, default values is None. Now support:

None
Auto
Gzip
Bz2
Brotli
Zstd
Deflate
RawDeflate
Lzo
Snappy
Xz

Examples:

set compression = 'Gzip';

empty_as_default

Format empty_as_default. Commonly used in stream load scenarios. It indicates whether the imported text is allowed to have empty values, default value is 1.

Examples:

set empty_as_default = 1;

enable_new_processor_framework

Enable new processor framework if value != 0. Default use new processor framework.

enable_planner_v2

Enable planner v2 by setting this variable to 1. Default use planner v2.

field_delimiter

Format field delimiter. Commonly used in stream load scenarios, default value:, .

Examples:

set field_delimiter = ',';
set field_delimiter = '|';

flight_client_timeout

Max duration the flight client request is allowed to take in seconds. By default, it is 60 seconds.

Examples:

set flight_client_timeout = 30;

group_by_two_level_threshold

The threshold of keys to open two-level aggregation, default value: 10000.

Examples:

set group_by_two_level_threshold = 10000;

max_block_size

Maximum block size for reading, default value: 10000.

Examples:

set max_block_size = 10000;

max_threads

The maximum number of threads to execute the request. By default, it is determined automatically. The value usually the same as the number of logical cpus.

Examples:

set max_threads = 8;

quoted_ident_case_sensitive

Case sensitivity of quoted identifiers. This is related to sql_dialect default value: 1 (aka case-sensitive).

Examples:

-- set to 0

databend :) set quoted_ident_case_sensitive = 0;

databend :) create table "T"("A" int);

databend :) insert into "t"("a") values(1);

databend :) select t.a from "T";
+------+
| a |
+------+
| 1 |
+------+

databend :) select t."a" from "T";
+------+
| a |
+------+
| 1 |
+------+

databend :) select t.A from "T";
+------+
| A |
+------+
| 1 |
+------+

-- set to 1

databend :) set quoted_ident_case_sensitive = 1;
Query OK, 0 rows affected (0.03 sec)

databend :) set sql_dialect = 'MySQL';

databend :) create table t(a string);

databend :) insert into t values("a");

databend :) set sql_dialect = 'postgresql';

databend :) insert into t values("a");
ERROR 1105 (HY000): Code: 1065, displayText = error:
--> SQL:1:2
|
1 | ("a")
| ^^^ column doesn't exist

record_delimiter

Format record_delimiter. Commonly used in stream load scenarios, default value: "\n"

Examples:

set record_delimiter='\n';

skip_header

Whether to skip the input header. Commonly used in stream load scenarios, default value: 0

If value greater than 0, that means the number of lines at the start of the file to skip.

Examples:

set skip_header=3;

sql_dialect

SQL dialect, support "PostgreSQL" "MySQL" and "Hive", default value: "PostgreSQL".

set sql_dialect='PostgreSQL';

storage_read_buffer_size

The size of buffer in bytes for buffered reader of dal. By default, it is 1MB.

Examples:

set storage_read_buffer_size = 1048576;

timezone

The server timezone, default value: "UTC".

Examples:

set timezone = 'Asia/Shanghai';

unquoted_ident_case_sensitive

Case sensitivity of unquoted identifiers, default value: 0 (aka case-insensitive).

Examples:

databend :) create table t(a string);

databend :) set unquoted_ident_case_sensitive=0;

databend :) create table T(a string);
ERROR 1105 (HY000): Code: 2302, displayText = Table 't' already exists.

databend :) set unquoted_ident_case_sensitive=1;

databend :) create table T(a string);

databend :) insert into t values(1);

databend :) insert into T values(2);

databend :) select * from t;
+------+
| a |
+------+
| 1 |
+------+

databend :) select * from T;
+------+
| a |
+------+
| 2 |
+------+

enable_async_insert

Whether the client open async insert mode, default value: 0.

wait_for_async_insert

Whether the client wait for the reply of async insert, default value: 1.

wait_for_async_insert_timeout

The timeout in seconds for waiting for processing of async insert, default value: 100.