Without mariadb quick, load data outfile performs really slow as it has to buffer the results from columnstore. To address quickly, columnstore enables mariadb quick by default on newer versions, but has the side effect of unfriendly output on simple queries, like show variables, show tables , show databases etc.

A longer term solution would have the mariadb server optimizer identify that the load data outfile is going to run against a columnstore table and to dynamically turn on mariadb quick

Customer experience:

[root@ip-172-31-35-155 rocky]#  mariadb -e "show status like '%Columnstore%';"

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| Columnstore_commit_hash | source |

| Columnstore_version | 23.10.3 |

+---------------+-------+