[MCOL-4497] Variable columnstore_use_import_for_batchinsert cannot be set dynamically Created: 2021-01-14  Updated: 2021-04-02  Resolved: 2021-02-01

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Manjot Singh (Inactive) Assignee: Gagan Goel (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

The variable columnstore_use_import_for_batchinsert cannot be modified dynamically.

From the MariaDB console doing:
"set global columnstore_use_import_for_batchinsert=ON;" the variable is not modified (it says "0 rows affected") and if you run "show variables like '%columnstore_use_import_for_batchinsert%';" you can see that the variable has the old value.

The only way to modify it is to change it on the configuration file and restart the server.

 Comments   
Comment by Gagan Goel (Inactive) [ 2021-02-01 ]

columnstore_use_import_for_batchinsert is an enum type with three possible values: OFF/ON/ALWAYS. The values need to be wrapped around single quotes as they are strings:

set columnstore_use_import_for_batchinsert='OFF';
 
set columnstore_use_import_for_batchinsert='ON';
 
set columnstore_use_import_for_batchinsert='ALWAYS';

Alternatively, numeric values can also be used:

set global columnstore_use_import_for_batchinsert=0; (OFF)
 
set global columnstore_use_import_for_batchinsert=1; (ON)
 
set global columnstore_use_import_for_batchinsert=2; (ALWAYS)

Generated at Thu Feb 08 02:50:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.