[MCOL-5370] review default for columnstore_use_import_for_batchinsert Created: 2022-12-22  Updated: 2023-12-15

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 23.10

Type: Task Priority: Major
Reporter: alexey vorovich (Inactive) Assignee: Max Mether
Resolution: Unresolved Votes: 0
Labels: cluster


 Description   

The default=on is changed to =always for docker/sky. This apparently disables rollback for batchinsert.
However there were historical reasons .
Needs review and unification with on prem

 Comments   
Comment by alexey vorovich (Inactive) [ 2022-12-22 ]

tntnatbry you mentioned that default should be =ON otherwise batch insert may fail rollback

Please comment/clarify and Todd will change docker to standard

Comment by David Hall (Inactive) [ 2023-01-04 ]

ON causes cpimport to be used for non-transactional insert but when insert is in a transaction, it uses the slower non-batch mode so rollbacks work.
AUTO causes cpimport to always be used, and ROLLBACK currently doesn't work in this mode.

Comment by Gagan Goel (Inactive) [ 2023-01-24 ]

toddstoffel Let's change the variable columnstore_use_import_for_batchinsert to ON in the docker image.

For more details about the various values that this variable supports, see MCOL-4000.

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